Hi Jason!

Sorry for the delayed answer, but until now I coldn't figure the exact
environment in wich the error appears.
So now I can tell you that it works when I assign EditSQL or KeyRelation,
BUT only if associated TIB_DataSource has AutoEdit := TRUE. If AutoEdit is
false, I get the same error even if EditSQL is assigned, and that's bad
because I have a situation where I can't use "SELECT Item1, (SELECT ... ) as
Item2" and also I want that my records to be edited only when a user presses
a specific button (so AutoEdit := False; AutoInsert := False).

Is there any other solution?
Thanks,
Gabriel

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, June 27, 2001 9:12 PM
Subject: Re: [IBO] Problems porting app from 3.6Cf to 4.0 GOLD A


> This sounds to me like a problem with IBO being able to figure out how to
> deliver the query live.
> Rather than getting rid of the join, try assigning your own EditSQL and
see
> if that helps resolve it too.
>
> Thanks,
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
>
> ----- Original Message -----
> From: <gjuncu@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Wednesday, June 27, 2001 6:17 AM
> Subject: Re: [IBO] Problems porting app from 3.6Cf to 4.0 GOLD A
>
>
> > 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
> > > >
> >
> >
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
>
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>