Hi,
I have a Bizobj that contains several joins. The tables I'm joining contain
dup field names.
Table a
fk_apvendno - the FK for the vendor number
Table b
fk_apvendno - the FK for the vendor number
So in the Bizobj -
I am required to add the table name to identify the field i.e.
addField('a.fk_apvendno')
so that the select statement correctly identifies the fk_apvendno in question.
Otherwise I get the error "fk_apvendno" not unique. This way of identifying
the fields in general work until I use the field in a grid.
The select statement returns only the field name in the dict i.e
{"fk_apvendno": 27}
But the grid is looking for 'a.fk_apvendno' which is the fieldname/key passed
from the bizobj. So I get an error because the key can not be found in the
DataSet.
I have worked around this issue. But I wonder if others see this as an issue?
And going forward how should it work? Or maybe I have completely missed how
the grid does work!
--
John Fabiani
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
