Hello,
I try to use SQLite (2.8) for a project, and ran into (what seems to be)
a little problem.
A MySQL-valid SELECT request only output 'Incomplete SQL' with SQLite. I
guess my SQL isn't standard enough, but I can't find what's wrong.
Incomplete SQL: SELECT r.Id, r.IdParams, r.SagN2, r.SagL2, r.SagN3,
r.SagL3, r.SagN4, r.SagL4, r.SagN5, r.SagL5 FROM results AS r, params AS
p WHERE r.IdParams = p.Id AND p.GarId = 0 AND Inc > 29.9999 AND Inc <
30.0001 AND Gdi > -5.0001 AND Gdi < -4.9999 AND Gda > -5.0001 AND Gda <
-4.9999 AND Mud > 1.5999 AND Mud < 1.6001 AND Fric > 0.1999 AND Fric <
0.2001 AND Ovg > 0.2499 AND Ovg < 0.2501 AND Mwd > 2.9999 AND Mwd <
3.0001 LIMIT 1
Any ideas ?
Thanks
--
Boris Herbinière-Sève
Technical Support
