johnf wrote:
> 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!
You should addField('a.fk_apvendno as a_apvendno') so you know the alias
that will be used for that field name. Or, you could figure out the
alias yourself by looking at the DataStructure.
--
pkm ~ http://paulmcnett.com
_______________________________________________
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]
