Hi Jason,

I investigate the Company sample, as you suggested, an it works ok as
is, but I have found the case when it fails. I still use my example,
since it is more simple than "Company":

If Clients_Qry from my sample is without JOINS, everything works ok:
---Begin SQL--------------
select * from CLIENTS
---End SQL----------------

If Clients_Qry is as in COMPANY sample:
---Begin SQL--------------
select
CLIENTS.*,
(select
COUNTRIES.NAME
from
COUNTRIES
where
COUNTRIES.ID = CLIENTS.COUNTRY_ID
) as COUNTRY_NAME,
(select
CITIES.NAME
from
CITIES
where
CITIES.ID = CLIENTS.CITY_ID
) as CITY_NAME
from
CLIENTS
---End SQL----------------

everything is OK.

But for

---Begin SQL--------------
select
CLIENTS.*,
CONTRIES.NAME COUNTRY_NAME,
CITIES.NAME CITY_NAME
from
CLIENTS left join COUNTRIES
on CLIENTS.COUNTRY_ID = CONTRIES.ID
left join CITIES
on CLIENTS.CITY_ID = CITIES.ID
---End SQL----------------

or

---Begin SQL--------------
select
CLIENTS.*,
CONTRIES.NAME COUNTRY_NAME,
CITIES.NAME CITY_NAME
from
CLIENTS,
COUNTRIES,
CLIENTS
where
CLIENTS.COUNTRY_ID = CONTRIES.ID and
CLIENTS.CITY_ID = CITIES.ID
---End SQL----------------

it doesn't work and I get the error explained in my previous message.

HTH,
Gabriel

--- In IBObjects@y..., "Jason Wharton" <jwharton@i...> wrote:
> 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@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
> >