>in VFP 3.0
>
>I have something like this pseudo-code
>
>lcSQl_Sta='Select * from Table2"
>
>lc1=lcProgramdefinedval1
>lc2=lcProgramdefinedval2
>lc3=allt(str(lnProgramdefinedval3))
>and so on...
>
>**I then create a passthrough statement like this
>
>lcSql_Sta="Insert Table(Field1,Field2..... ) " +; "values('&lc1',"+allt(str(lc3))+",'&lc2'.....)"
>
>
>wait window lcSql_Sta <--- this window displays 'Select * from Table2'
>
>lsql='test'
>
>wait window lcSql_Sta <-- this window dislays 'test'
>
>Question-- Is there anything in my code that prevents the proper assignment of the lcSql_Sta variable?
Check the line before the second assignment to lcSql_sta, it may be a comment that ends with a semi colon.