Hi Francois.
db.define_table('accountfromchart',
SQLField('number', length=10),
SQLField('description', length=155),
SQLField('parentaccount', "reference
accountfromchart")
)
db.accountfromchart.parentaccount.requires=IS_IN_DB
(db,'accountfromchart.id','accountfromchart.description')
Massimo
On Jun 9, 2:51 pm, "Francois (Jersey)"
<[email protected]> wrote:
> I am creating a simple model to represent a chart of accounts:
>
> For example, we have
>
> 0. top account
> 1. Account 1
> 1.1 account 1.1
> 1.11
> 1.12
> 1.13
> 1.2
> (...)
> 2.
> 2.1
> 2.2
> 2.21
> 2.22
>
> The model is as below :
>
> db.define_table('accountfromchart',
> SQLField('number', length=10),
> SQLField('description', length=155),
> SQLField('parentaccount', db.accountfromchart)
> )
>
> db.accountfromchart.parentaccount.requires=IS_IN_DB
> (db,'accountfromchart.id','accountfromchart.description')
>
> So I am trying to have a nested database to represent the chart of
> accounts, where for example the parent account of 2.22 is 2.2, and
> where the parent account of 2.2 is 2, and the parent accounts of 2. is
> account is zero.
>
> I believe that using a foreign key would be the best option to do so,
> but it fails with the following message:
>
> Traceback (most recent call last):
> File "/home/francois/web2py/gluon/restricted.py", line 107, in
> restricted
> exec ccode in environment
> File "/home/francois/web2py/applications/cookbook4/models/db.py",
> line 41, in <module>
> SQLField('parentaccount', db.accountfromchart.id)
> File "/home/francois/web2py/gluon/sql.py", line 520, in __getattr__
> return self[key]
> File "/home/francois/web2py/gluon/sql.py", line 514, in __getitem__
> return dict.__getitem__(self, str(key))
> KeyError: 'accountfromchart'
>
> Where am i wrong? what is my mistake?
>
> Thanks,
>
> Francois
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
