>>Hi,
>>
>>I have been trying to create an expression to use with a macro or evaluate() function to do the following:
>>
>>I want to SCAN through records of a VFP table and for each record execute SQLEXEC() function to add this record to the SQL Server table. The template of the expression is as following:
>>

>>cExpr = "insert into MyTable (fld1, fld2, fld3) values (?fld1, ?fld2, ?fld3)"
>>*-- Then execute the expression
>>SQLEXEC(hCon,cExpr)	
>>

>>
>>The problem is that I can't create the expression such that I can execute it as following:
>>

>>SELECT MyVfpTable
>>SCAN
>>      *-- the following does not work
>>      cExpr = &cExpr.
>>      *-- the following does not work either.
>>      cExpr = evaluate(cExpr) 
>>      SQLEXEC(hCon,cExpr)	
>>ENDSCAN
>>

>>
>>I would appreciate any suggestions on how to make this expression. TIA.
>
>I don't understand what is the problem?
>This should work:
>

>cExpr = "insert into MyTable (fld1, fld2, fld3) values (?MyVfpTable.fld1, ?MyVfpTable.fld2, ?MyVfpTable.fld3)"
>SCAN
>    SQLEXEC(hCon,cExpr)
>ENDSCAN
>

Somehow when I was doing exactly what you showed in your example, I was getting error. Let me try again. thank you.