query problem (LIMIT)

[Lemon]

I'm trying to do the folowing query:

 

MyCommand = New OleDbCommand("SELECT id FROM wedstrijden ORDER BY id DESC LIMIT 0,1", MyConnection)
MyReader = MyCommand.ExecuteReader()
MyReader.Read()

 

But then i get an error:

 

An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll

 

 

 

I'm very sure that the table name enc is correct.

 

 

When i try this, everything works:

MyCommand = New OleDbCommand("SELECT id FROM wedstrijden ORDER BY id DESC", MyConnection)
MyReader = MyCommand.ExecuteReader()
MyReader.Read()

 

So the problem is the LIMIT, i am used to this thing in sql with php. Is it possible that it doesnt work in de sql query with an acces db?

[JABE]

Afaik, LIMIT is proprietary to the mySQL database.

[Nerseus]

You could say "SELECT TOP 1 ...". I'm not sure if that's what the LIMIT thing does...

 

-Nerseus