|Subject||RE: [IBO] Singleton select error|
|Author||Daniel R. Jimenez|
> We have a DB app, which allows users to browse a record (call it recordI have notice that in my original SQL for the IB_Query responsible for the
> This record (A) has a FK to another table, so the FK is a TIB_LookupCombo.
> Say the application user was to open the form which allows him/her to
> the above mention record (A). Say that the application user also opens
> another form to edit the content of the FK record (call it record B)
> reference by record (A).
> Once she/he has modified record (B) and committed the changes. The
> application calls RefreshAll() on the query responsible for the dropdown
> (TIB_LookupCombo), at this stage I am getting a Singleton error but I am
> sure how this is possible. On the other hand, if I use Unprepare, Prepare
> and Execute the error no longer appears, but the TIB_LookupCombo no longer
> displays the FK record(B) associated to record (A) as selected, it just
> appears as one of the available records in the dropdown.
> I am not sure if the above description of the problem is sufficient. If
> please ask for the any further information you require.
> Thank you
And the KeyLinks property had:
If I modify the SQL to be:
USERS.USERS_ID // This is the only difference to the original SQL
The problem goes away. Why????