The following query:
select * from table where (1=1) and ForignKey in ( 0, 2, 3 )
returns an error if I try to open it with RequestLive set to true. If I set RequestLive to false then it opens ok.
I need to edit the values returned by this query. Is there a way??
I know that using ADO will solve my problem but since I am planning to run this program with other databases I cannot switch to ADO right now.
Delphi 5, updates 1 and 2.