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
Stephan Hennekens
Alterra, Wageningen, The Netherlands
Tel: +31 317 485887 (06-49394675)
http://www.synbiosys.alterra.nl/lvd
<http://www.synbiosys.alterra.nl/lvd>
http://www.synbiosys.alterra.nl/natura2000
<http://www.synbiosys.alterra.nl/natura2000>
http://www.synbiosys.alterra.nl/turboveg
<http://www.synbiosys.alterra.nl/turboveg>
