Subject | LookupKeyForFields vs. LookupKeyForBufferFields |
---|---|
Author | raoul.sitasoftware |
Post date | 2006-03-29T12:44:40Z |
Hi!
Could someone please explain the difference between
1)LookupKeyForFields and 2)LookupKeyForBufferFields from the
TIB_BDataSet? I'm getting familiar with IBO and wondered what these
are for.
First, I thought 1) would do a Lookup only on server and 2) would do a
Lookup on Buffer and, if not found in buffer, then on server. Now I
don't understand anything because I won't get results with both of them.
My simple use case: I use a TIB_Query, I set 2 KeyLinks, let's say ID1
and ID2, as statement I use a SELECT * FROM. Before the Lookup I set
the values for ID1 and ID2 in the KeyFields. After Lookup I get the
desired value from the searched record with BufferFieldByName('FIELD').
When I open the dataset before Lookup I get always the SAME record as
result of my Lookup, when I don't open the dataset I get no results;-)
What am I understanding or doing wrong?
Thx for your help!
Raoul
Could someone please explain the difference between
1)LookupKeyForFields and 2)LookupKeyForBufferFields from the
TIB_BDataSet? I'm getting familiar with IBO and wondered what these
are for.
First, I thought 1) would do a Lookup only on server and 2) would do a
Lookup on Buffer and, if not found in buffer, then on server. Now I
don't understand anything because I won't get results with both of them.
My simple use case: I use a TIB_Query, I set 2 KeyLinks, let's say ID1
and ID2, as statement I use a SELECT * FROM. Before the Lookup I set
the values for ID1 and ID2 in the KeyFields. After Lookup I get the
desired value from the searched record with BufferFieldByName('FIELD').
When I open the dataset before Lookup I get always the SAME record as
result of my Lookup, when I don't open the dataset I get no results;-)
What am I understanding or doing wrong?
Thx for your help!
Raoul