[Sqlite Laz error] Yet another simple query. Can't set limit?

[Sandrix]

I have a simple query:

Code: [Select]

Query.SQL.Text  := 'select id from  eng  where eng like "'call%" limit 10';

select * from  eng  where  eng like "call%" limit 10

Getting an error in runtime:

near "order": syntax error

What's wrong?

[Marc]

don't use "limit 10"
I think Query adds a sort by appending "order by" to your sering.

[Lacak2]

Which Data-access components do you use ? (sqlDB, Zeos)?

[Sandrix]

lol But I want/need to use it : )

if it adds "order by" automatically it means that I can't use "order by" either?

I'm using SQLdb, zeos is too buggy(especially on Mac)

[Mujie]

Watch your fingers from typo 

How about this ?

Code: [Select]

Query.SQL.Text  := 'SELECT id FROM eng WHERE eng LIKE "call%" ORDER BY id ASC LIMIT 10';


[Sandrix]

  lol it works.. thank a lot I'd never figure it out  by myself