>I don't know how to make this work:
>
>lcfyr =cursor.fyr
>lcflag = 1 && this is a "bit" data type in SQL server
>
>cSQL="INSERT INTO Table (fyr,Flag)"
>cSQL=cSQL + " VALUES ('"+lcfyr+"',"+lcflag+")"
>
>Now when I check the variable in DEBUG lcflag is 1 numeric, but it desn't insert, I get a operator/oparand error
Since you are building up a character string, you need to convert it to a character value:
cSQL="INSERT INTO Table (fyr,Flag)"
cSQL=cSQL + " VALUES ('"+lcfyr+"',"+
ALLTRIM(STR(lcflag
))+")"