Subject Re: [IBO] Question about KeySource property
Author Helen Borrie (TeamIBO)
At 02:18 PM 17-01-02 +0000, you wrote:
>I have a TIB_LookupCombo on a form that has its KeySource property
>set so that I can automatically update a field in the KeySource query
>based on the selection made in the lookup combo. This works fine.
>However, if I try to bring up the form that allows be to add new
>records to the query with its KeySource set I get an error message
>that says dataset cazn not scroll. The only way around this is to se
>the KeySource property to Nil before opening the query then resetting
>it after closing the query. Is this the correct procedure or am I
>doing something wrong ?

Well, the reason the Lookup dataset can't scroll is because the current record in the Keysource dataset has it "anchored" on a certain lookup record.

One way to fix this is to use another query for maintaining the lookup table and to refresh the lookup dataset when the maintenance query has posted its insert (if they are in the same transaction) or when it has committed its insert (if they are in different transactions). Make sure the lookup dataset has its isolation set to tiCommitted in that case, otherwise the main transaction won't see the changes from the other transaction.

Helen Borrie (TeamIBO Support)

** Please don't email your support questions privately **
Ask on the list and everyone benefits
Don't forget the IB Objects online FAQ - link from any page at