[yunqa.de] Re: using IN statement in a SELECT query
- From: "Hennekens, Stephan" <Stephan.Hennekens@xxxxxx>
- To: <yunqa@xxxxxxxxxxxxx>
- Date: Tue, 9 Sep 2008 12:14:15 +0200
Ralf,
I did buy the professional version, and now it works.
Outstanding work!
Regards,
Stephan
Stephan Hennekens
Alterra, Wageningen, The Netherlands
Tel: +31 317 485887 (06-49394675)
http://www.synbiosys.alterra.nl/lvd
http://www.synbiosys.alterra.nl/natura2000
http://www.synbiosys.alterra.nl/turboveg
> -----Original Message-----
> From: yunqa-bounce@xxxxxxxxxxxxx
> [mailto:yunqa-bounce@xxxxxxxxxxxxx] On Behalf Of Hennekens, Stephan
> Sent: dinsdag 9 september 2008 10:51
> To: yunqa@xxxxxxxxxxxxx
> Subject: [yunqa.de] Re: using IN statement in a SELECT query
>
> Thanks Ralf,
>
> I am indeed using the Personal flavor. A good reason to the
> buy the Professional version.
>
> Regards,
> Stephan
>
> Stephan Hennekens
> Alterra, Wageningen, The Netherlands
> Tel: +31 317 485887 (06-49394675)
> http://www.synbiosys.alterra.nl/lvd
> http://www.synbiosys.alterra.nl/natura2000
> http://www.synbiosys.alterra.nl/turboveg
>
>
>
>
>
> > -----Original Message-----
> > From: yunqa-bounce@xxxxxxxxxxxxx
> > [mailto:yunqa-bounce@xxxxxxxxxxxxx] On Behalf Of Delphi Inspiration
> > Sent: dinsdag 9 september 2008 10:46
> > To: yunqa@xxxxxxxxxxxxx
> > Subject: [yunqa.de] Re: using IN statement in a SELECT query
> >
> > Hennekens, Stephan wrote:
> >
> > > When I run an sql select query like mentioned below
> > a run error occurs. Running the same query with the program
> SQLiteSpy
> > then no error occurs.
> > > Might there be a problem with the
> > TDISQLite3Statement object that does not except the IN statement?
> > >
> > > Regards,
> > > Stephan
> > >
> > > stmt: TDISQLite3Statement;
> > >
> > > sql := 'SELECT * FROM customers WHERE id IN (1,2,3,4)';
> > >
> > > stmt := FDatabase.Prepare16(sql);
> > >
> > > ==> SQLIte Error 1: near "IN": syntax error
> >
> > I suppose you are running DISQLite3 Personal?
> >
> > Sub-queries, sub-selects, and the IN() operator are supported by
> > DISQLite3 Professional only. See this feature comparison chart for
> > details:
> >
> > http://www.yunqa.de/delphi/doku.php/products/sqlite3/feature_chart
> >
> > The following change makes your SQL compatible with DISQLite3
> > Personal:
> >
> > SELECT * FROM customers WHERE id=1 or id=2 or id=3 or id=4;
> >
> > Ralf
> >
> > _______________________________________________
> > Delphi Inspiration mailing list
> > yunqa@xxxxxxxxxxxxx
> > //www.freelists.org/list/yunqa
> >
> >
> >
> >
> >
>
> _______________________________________________
> Delphi Inspiration mailing list
> yunqa@xxxxxxxxxxxxx
> //www.freelists.org/list/yunqa
>
>
>
>
>
_______________________________________________
Delphi Inspiration mailing list
yunqa@xxxxxxxxxxxxx
//www.freelists.org/list/yunqa
Other related posts:
