DELPHI AREA Forum

Hi,
I have a little problem with SQL.
I wrote this :
SELECT * FROM <table_name> ORDER BY <field_name> LIMIT 0,10
but it doesn't work.
I need to show 10 highest products. I wrote it like i used to in MySQL but it seems that Delphi use different writing.
Anyone can help me?
Thanks.

Regards,

Delphi does not specifically support one implementation of SQL, it is the application's underlying database that determines what dialect you have to use.

Anyway, here's a URL whcih covers this topic extensively:

http://groups.google.nl/groups?hl=nl&lr;=&threadm;=aae1fe62.0209161432.303036c3%40posting.google.com&rnum;=1&prev;=/groups%3Fq%3DMySQL%2BLIMIT%2BSQL%26hl%3Dnl%26lr%3D%26selm%3Daae1fe62.0209161432.303036c3%2540posting.google.com%26rnum%3D1

Hope this helps,

Stefan