[Sqlite Laz error] Yet another simple query.  Can't set limit?
lazarus / 16-Databases

----------------------------------------------------------------------
Sandrix · 2010-07-22 16:45

I have a simple query:

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

Quoteselect * from  eng  where  eng like "call%" limit 10
Getting an error in runtime:

Quotenear "order": syntax error
What's wrong?

----------------------------------------------------------------------
Marc · 2010-07-22 22:54

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

----------------------------------------------------------------------
Lacak2 · 2010-07-23 05:31

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

----------------------------------------------------------------------
Sandrix · 2010-07-23 10:58

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 · 2010-07-25 15:31

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 · 2010-07-26 11:49

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