SQL LIMIT on MySQL/ODBC connection

avantman42

I'm trying to replace an MS Works database at work with MySQL running on Debian, with OOo for the front-end. The following SQL returns errors:

dfrench · Posted: Sat Feb 14, 2004 10:34 am Post subject:

There are 8 references to "parse error" in these forums. Most of which lead to a suggested solution ... set on "Run SQL Directly".
for example:
http://www.oooforum.org/forum/viewtopic.php?p=18656&highlight=parse+error#18656

Did you have that setting ?

dfrench · Posted: Sat Feb 14, 2004 10:51 am Post subject:

MySQl supports autoincrement which may be a better way of implementing your which number to use next especially if the database becomes large or has to support concurrent update-access.

avantman42 · Posted: Sun Feb 15, 2004 11:38 pm Post subject:

Thanks dfrench,

By the time I posted that message, I'd spent most of the afternoon trying to get something working, including a lot of time searching this forum. For some reason I didn't search for 'parse error' Embarassed

I now have the LIMIT working, but I cannot add new rows. Presumably this is because of the LIMIT.