Try this, Edgar:
lcfyr ="String" && Yes?
lcflag="1"
cSQL="INSERT INTO table (fyr,flag)"
cSQL=cSQL+" VALUES ('&lcfyr','&lcflag')"
>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
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05