Hi Michel,

>What would be the proper approach to benefit of the use of a variable in a SQLExec()? For example, I have a lcCustomerID variable that I would like to use such as:
>

Are you trying to use VFP variable as parameter for SQLEXEC?
Then correct syntax is:

lnResult=SQLExec(lnHandle,'SELECT * FROM MyTable WHERE CustomerID = ?lcCustomerID')

Just add question mark before variable name.

Thanks,
Aleksey.