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