Digital Workshop

Is there a limit sql function that can be appled to a database call in Opus?

Iv'e tried as in the example below and get no results returned.

var records = mydb.ExecuteSQL("SELECT * FROM TelLog ORDER BY tel_RecNo DESC LIMIT 50 ;")

All works ok without the LIMIT statement?

Like a lot of SQL Limit is DB specific - which one are you connecting to?

Also, limit can take two parameters, the starting position and the number of rows to return from said position IE:

Limit 10, 5

is start at row 10 of results and return five rows.


Mack

Possible syntax? Does semicolon belong inside ?

Thanks for the replies.

I am using an Access db and the problem still remains.

var records = mydb.ExecuteSQL("SELECT * FROM TelLog ORDER BY tel_RecNo DESC Limit 10,50")

Any further ideas?

Hi Andy,

Access doesn't use the Limit command as far as I know. You could try using the TOP command as:

SELECT TOP 5 column1, column2, dt FROM table ORDER BY dt DESC

Mack

RESOLVED

Thanks Mack, must brush up on my Access syntax - more used to MySql.