>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 ????
TEXT TO SQLCOMMAND NOSHOW PRETEXT 15
INSERT INTO TEMP (ID,IS_ACTIVATED) VALUES ('<<TRANSFORM(L_MYID)>>',<<IIF(L_BACTIVATED,1,0)>>)
ENDTEXT
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.