i want to do an insert in a sql server tables, so i do my insert sentence in a variable.
SQLCOMMAND = "INSERT INTO TEMP (ID,IS_ACTIVATED) VALUES(" + ALLTRIM(STR(L_MYID)) + "," + L_BACTIVATED + ")", BUT I GET AND ERROR. L_BACTIVATED is a true or false value. Do i have to convert it ????