Subject Problems porting app from 3.6Cf to 4.0 GOLD A
Author Gabriel Juncu
Hi list!

I have a problem porting my app. from IBO 3.6Cf to 4.0 Gold A.
First the environment:

3 Tables:

CLIENTS
ID numeric(18,0) - primary key
COUNTRY_ID numeric(18, 0)
CITY_ID numeric (18, 0)

COUNTRIES
ID numeric(18,0) - primary key
NAME varchar(50)

CITIES
ID numeric(18,0) - primary key
NAME varchar(50)
COUNTRY_ID numeric(18, 0)

and 3 TIB_Querys:

Clients_Qry:
SQL: select * from CLIENTS
KeyLinks: ID
KeyLinksAutoDefine: FALSE

Countries_Qry:
SQL: select * from COUNTRIES
KeyLinks: COUNTRIES.ID = COUNTRY_ID
KeySource: Clients_Src
KeyLinksAutoDefine: FALSE

Cities_Qry:
SQL: select * from CITIES
KeyLinks: CITIES.ID = CITY_ID
KeySource: Clients_Src
MasterLinks: CITIES.COUNTRY_ID = COUNTRIES.ID
MasterSource: Countries_Src

In Form.Create:
Countries_Qry.Open;
Cities_Qry.Open;
Clients_Qry.Open;

What I wanted is that when a user inserts a new client and chooses one
country in Country_LookupCombo, only cities from that country would be
available in Cities_LookupCombo. And it worked ok in IBO 3.6Cf.
Now in IBO 4.0 Gold A I get 2 "Dataset can not scroll" errors when opening
the Client_Qry. If I first open Clients_Qry, then the error does not appear
when I create the form, but whei I scroll the query in IB_Grid.
If I set Cities_Qry.MasterSource := nil, everything is ok, except of course
that the cities are not filtered anymore.
Question:
Is this a normal behaviour, or is a bug? If it's normal, than probably I
have to filter the cities query in OnChange event of Countries_LookupCombo.

Thank you,
Gabriel