Subject | Re: [IBO] Problems porting app from 3.6Cf to 4.0 GOLD A |
---|---|
Author | Gabriel Juncu |
Post date | 2001-07-03T05:31:58Z |
Hi Jason!
I downloaded IBO4_Gold_A2, and everything works ok now!
Thanks!
Gabriel
[...3 messages from thread deleted...]
I downloaded IBO4_Gold_A2, and everything works ok now!
Thanks!
Gabriel
[...3 messages from thread deleted...]
> ----- Original Message -----
> From: "Gabriel Juncu" <gjuncu@c...>
> To: <IBObjects@y...>
> 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
>