Unable to convert SQL INSERT Script to DBExec

[skiko]

I am unable to convert the following SQL script into a macro, I can modify fields fine but cannot seem to get the insert function to work.

INSERT INTO ItemRecord (location,itemCode) values (0,00026600303167)

DBConnect>Driver={SQL Server};Server=%SQL_SERVER%\ACS;Database=item;Uid=sa;Pwd=%PASS%;,dbH
DBExec>dbH,ItemRecord (location,itemCode) values (0,00026600303167),r
DBCLOSE>dbH

Anyone have any suggestions???

[TheEek]

Did you try:

Code: Select all

Let>SQLCmd=INSERT INTO ItemRecord (location,itemCode) values (0,00026600303167) 
DBConnect>Driver={SQL Server};Server=%SQL_SERVER%\ACS;Database=item;Uid=sa;Pwd=%PASS%;,dbH
DBExec>dbH,SQLCmd,r
DBCLOSE>dbH

I'm just not so sure about the SQL syntax. Best thing to do would be to try this within a command line (or myphpadmin - if using mysql) connection.

[skiko]

Worked Great!!!!


I am assuming you can do the same thing with UPDATE.

THANKS!!!