If you are aware of a case where such does not work in TIBOTable, I would
like to fix it. There is no reason it shouldn't work equally well. Can you
help me identify where it doesn't work as well?

Thanks,
Jason

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of Hans
Sent: Friday, April 19, 2013 12:46 AM
To: IBObjects@yahoogroups.com
Subject: RE: [IBO] TIBOTable.Locate on a lookup field fails

Drop TIBOTables and replace them by TIBOQuerys and all Master/Detail
relationships work just great. Even better than documented

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of masonwheeler
Sent: Thursday, April 18, 2013 11:45 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] TIBOTable.Locate on a lookup field fails

Got another fun one for you.

Create two database tables, linked by a FK relationship.

Create two TIBOTable objects, one for each table.

Use the form designer to create persistent fields for one of the TIBOTable
datasets. Give it the fields the underlying table has, plus one more, a
field of FieldKind fkLookup, that looks up a property on the other dataset,
using the FK relationship.

Create a routine that tries to call Locate on this dataset, and use the
lookup field for the Locate key field.

Expected: It should work. This will work on normal datasets.

Observed: EIB_StatementError. FieldName: [lookup field name] not found.

It appears to be looking for the field in the underlying dataset, and then
bailing when it's not found.

Mason



------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links





------------------------------------

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links