Hi,

I am using dbisam 3.30
I have a tdbisamtable component
In the delphi IDE I defined a lookupfield to the table defenition.
The lookupfield has to lookup the data using two fields.
So far so good, all works

Now I want to lookup using only one field and a stringvalue instead of the other field
Is this possible?


Thanks
Wim

Wim


Not by linking the tables in a master detail relationship but you can by making a calcfield and doing the lookup youself with .Locate()

Roy Lambert [Team Elevate]

Roy,

I'm already using calculated fields with findkey as a workaroud.
But a lookup field is much faster.

Any ideas ?

Wim

Wim


The only one that will work is to add a stringfield into the table(s) so that it can be used as part of the lookup definition. There is no way I know of to use a constant in these circumstances.

You may want to try a query as the mechanism to obtain the field - a prepared query may be faster than a FindKey since I seem to remember multi field FindKeys being a bit slow in V3 - can't remember if it was DBISAM or VarArrayOf or what.

Roy Lambert [Team Elevate]