Insert into Error

Ronnie Dackus · **Posted:** May 25th, 2007, 6:59 pm

Hi,

I can not find the syntaxt error! :oops:

Code:

db.ExecuteSQL("INSERT INTO Orderregels (Artikelregel) VALUES ('"+paneelcode+"') (Orderkop) VALUES ('"+ordernummer+"')");
}

Hope that somebody can see it, to long behind the keyboard?!

Regards,

Ronnie

Lar_123 · **Posted:** May 25th, 2007, 8:46 pm

I'm very limited in experience with scripting.
Others here may hone in on the issue immediately...

Meanwhile:
* the Help examples show an Asterisk between SELECT * FROM. Do you need one here.
* Examples also show the Execute statement within an Expression. Do you need to set a var xyz = _______ .
* Is it possible "db" is a reserved word? Try db1 instead. (doubt that's it, but)
* I assume you've got your brackets in order.

Good luck.

opuslover · **Joined:** September 11th, 2006, 2:38 pm **Posts:** 125

TRy this:

Code:

db.ExecuteSQL("INSERT INTO Orderregels (Artikelregel,Orderkop) VALUES ('"+paneelcode+"','"+ordernummer+"')")

Paul · **Posted:** May 25th, 2007, 9:05 pm

Is the final curly bracket supposed to be there?
Remove it and there is no syntax error (as far as Opus is concerned), as long as the script is on one line.

Paul

Ronnie Dackus · **Posted:** May 27th, 2007, 1:27 pm

Thanks for the reactions: :wink:

the correct code

Code:

db.ExecuteSQL("INSERT INTO Orderregels (Artikelregel, Orderkop, recept )VALUES ('"+searchrecept+"', '"+ordernummer+"', '"+receptTXT+"')")

Regards

Ronnie

Digital Workshop

Insert into Error

Who is online