>>>OK Here's my solution. Thanks to all of you who contributed.
>>>Borislav - I don't see the need for your form of ?m.lcPermID since lcPermID is a local variable and the select is called only once. Perhaps I am missing something.
>>>
>>>lcSQL = "select * " + ;
>>> "from TRPSurvey" + "..exported " + ;
>>> "where ltrim(rtrim(PermID)) = " + lcPermID
>>>
>>>IF sqlexec(m.lnHandle,lcSQL,"crsImport") < 0
>>> AERROR(laError)
>>> MessageBox(laError[1,2])
>>>ENDIF
>>>
>>
>>How does it work? I do not see lcPermID surrounded by single quote.
>
>It works fine. lcPermID is a variable containing a character string. So its a simple concatenation.
Watch for my upcoming FoxPro Advisor article.