I have the following table def:
db.define_table('processes',
Field('itemcode',db.commodities,label=T('Item
Code'),unique=True, required=True, notnull=True), # Item code of the
process result
Field('name','string',length=60,label=T('Name'), required=False,
notnull=False),
Field('description','text',length=8*1024,label=T('Description'),
required=False, notnull=False),
format='%(itemcode)s-%(name)s'
)
db.define_table('processitems',
Field('process',db.processes, label=T('Process'), required=True,
notnull=True),
Field('itemcode',db.commodities, label=T('Item Code'),
required=True, notnull=True),
Field('amount','double',label=T('Amount'), required=True,
notnull=True),
format = '%(process)s-%(itemcode)s'
)
and this is the controller:
def receipe():
tbl = db.processes
fields = [tbl.itemcode,tbl.name]
query = (tbl.id>0)
order = [tbl.itemcode]
maxlen = {'prosesses.itemcode':5,'processes.name':25}
return dict(grid=SQLFORM.smartgrid(db.processes,fields=fields,
csv=False, orderby=order,maxtextlengths=maxlen))
Everytime I try to list the processitems, I get no dataset and this
message:
Query Not Supported: no such column: processes.itemcode
What did I wrong?
--
