Syntax Error

[DM Agonia]

Hi all..

Here's my problem.

I'm using NWNX with SQLITE. I've installed NWNX and ODBC.

Now..

I'm trying to delete a single row from a silly table...but...here's the mistake.

! SQL Error: near "LIMIT": syntax error

Here's my call..

sSQL = "DELETE * FROM vendor_png WHERE png_tag='"+ sPngTag +"' AND obj_resref='"+ sResRef +"' AND obj_stacksize='"+ sStackSize +"' AND pg_name='"+ sName +"' AND pg_account='"+ sAccount +"' LIMIT 1";


What do you think about?

Thank you.

[virusman]

In SQLite, you can specify LIMIT for SELECT queries only.

[DM Agonia]

I had the same error with DAY() and MOUNTH() functions..


But..how can i delete a single row then?

[virusman]

SQLite syntax is not identical to MySQL. Refer to the SQLite documentation:
http://www.sqlite.org/lang.html

[DM Agonia]

so i have to wite limit 1 offset 0?

In that link there's the delete-smt-limited

[virusman]

[DM Agonia]

I'm not so nerd...and i'm under windows..

How can i use limit in sqlite or something like that? I've to delete only one row of due-tree-four identical..

[Fireboar]

Where's your primary key? This is exactly the reason that primary keys are so important. EVERY table must have a primary key. It can be composite, but without a primary key, you get into all sorts of problems like this.

In SQLite there is no ALTER TABLE function, so you should use CREATE TEMPORARY TABLE to clone the existing table, copy all the data across, then delete the old table, CREATE TABLE a new one with an auto-incrementing ID field or something and finally copy the data across.

Not neat, but better than not having a primary key.

[Xildjian]

Don't you want just a DELETE instead of DELETE * ?

I had an issue like that the other day, where the DELETE * was not correct syntax.
_________________
Member Shadow of Iniquity development team

[Fireboar]