Limit count of records at SELECT query 1

[chilloutfuchs]

Hi,

I 've change my database server from mysql to pervasive sql 2000. I 've many query's lokking like this:
"SELECT * FROM database WHERE name = 'hans' LIMIT 1,5"
The Problem is: Pervasive don't know the LIMIT-statement. But i had to select only the first 5... How can i do this on Pervasive?

Sorry for my poor english and thanks for help!

 

[zemp]

Pervasive 2000 does not have a simple way of doing this in the SQL statement.

If you are using ADO you can use a client side cursor and try setting the ADO recordset object's .maxrecords property.

Pervasive V8, however, does support the 'TOP' keyword. So you can do something like 'Select Top 10 * From table1'.

Take Care,

zemp