This sounds like a bug to me.
Will you take a look at the Company sample application and see if you can
get it to do the same problem?

Thanks,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Gabriel Juncu" <gjuncu@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 27, 2001 2:31 AM
Subject: [IBO] Problems porting app from 3.6Cf to 4.0 GOLD A


> 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
>
>
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>