>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 ????
try:
"INSERT INTO TEMP (ID,IS_ACTIVATED) VALUES(" + ALLTRIM(STR(L_MYID)) + "," + iif(L_BACTIVATED,"1","0") + ")"
If it's not broken, fix it until it is.
My Blog