I am trying to build my input string forODBC_EXECUTE to execute and keep getting an error. when I hard code the string it enters fine into my sql database.
This is how I am building my string:
INPUT_STRING = "INSERT INTO number4 VALUES ('005', " + itos(NEW_NUMBER) +", 'XX', " + MKUPPER(DESCRIPTION) + ", " + MKUPPER(USERNAME) + ", " + DATE + ", " + PROJ_NO + ")"
When I print the input_string variable it looks just like the hard coded one except my new number has increased by 1. Any help would be great.
You can use variables to pass the VALUES into the statement as shown below:
DB table name = number4
DB table field names = description, username, date
DECLARE_VARIABLE STRING string1 "TEST7"
DECLARE_VARIABLE STRING string2 "WBECK"
DECLARE_VARIABLE STRING string3 "10/25/2013"
DECLARE_VARIABLE STRING INSERT_QUERY
INSERT_QUERY = "INSERT INTO number4 (description, username, date) VALUES ("+string1+", "+string2 +", "+string3 +")"PRINT "%" UPDATE_QUERYODBC_EXECUTE UPDATE_QUERY