Subject Re: [IBO] Problem in BidingCursor.
Author Virtual Memory
yes

the table is

CREATE TABLE L126 (
L126_L005_CGC CHAR_15 NOT NULL,
L126_L125_CODIGO INTEIRO NOT NULL,
L126_ALIQUOTA VALOR_2 NOT NULL,
L126_OBS CHAR_255 COLLATE PT_PT);

ALTER TABLE L126 ADD CONSTRAINT L126_PK PRIMARY KEY (L126_L005_CGC,
L126_L125_CODIGO);

and the select is

SELECT
S.L126_L005_CGC,
S.L126_L125_CODIGO,
S.L126_ALIQUOTA,
S.L126_OBS
FROM
L126 S
WHERE
S.L126_L005_CGC= :L005_CGC


Virtual Memory Developer System
Flavio Macedo :.
Diretor
----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, December 02, 2002 5:35 PM
Subject: Re: [IBO] Problem in BidingCursor.


> Does the table have a primary key?
>
> Jason Wharton
> CPS - Mesa AZ
> http://www.ibobjects.com
>
> -- We may not have it all together --
> -- But together we have it all --
>
>
> ----- Original Message -----
> From: "Virtual Memory" <virtual@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Monday, December 02, 2002 10:10 AM
> Subject: Re: [IBO] Problem in BidingCursor.
>
>
> > Hey Jason
> >
> > I don't understand as well as it works this property. This mistake this
> > happening in select very simple:
> >
> > select * from L017 where l017_codigo = '0100'
> >
> > Virtual Memory Developer System
> > Flavio Macedo :.
> > Diretor
> > ----- Original Message -----
> > From: "Jason Wharton" <jwharton@...>
> > To: <IBObjects@yahoogroups.com>
> > Sent: Monday, December 02, 2002 3:48 PM
> > Subject: Re: [IBO] Problem in BidingCursor.
> >
> >
> > > Sounds as though you need to make proper KeyLinks settings.
> > >
> > > Jason Wharton
> > > CPS - Mesa AZ
> > > http://www.ibobjects.com
> > >
> > > -- We may not have it all together --
> > > -- But together we have it all --
> > >
> > >
> > > ----- Original Message -----
> > > From: "Virtual Memory" <virtual@...>
> > > To: "IBO" <IBObjects@yahoogroups.com>
> > > Sent: Monday, December 02, 2002 8:24 AM
> > > Subject: [IBO] Problem in BidingCursor.
> > >
> > >
> > > > When executing the component recording transaction TIBOQUERY after
the
> > > command ApplayUpdates receive the following mistake:
> > > >
> > > >
> > > > Problem in BidingCursor.
> > > >
> > > > Virtual Memory Developer System
> > > > Flavio Macedo :.
> > > > Diretor
>
>
>
>
>
___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
InterBase
> without the need for BDE, ODBC or any other layer.
>
___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
papers,
> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.423 / Virus Database: 238 - Release Date: 25/11/2002