[yunqa.de] Re: using IN statement in a SELECT query
- From: "Hennekens, Stephan" <Stephan.Hennekens@xxxxxx>
- To: <yunqa@xxxxxxxxxxxxx>
- Date: Tue, 9 Sep 2008 10:51:10 +0200
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
Other related posts:
