>>How can I execute a SQL statement stored as a character string. In the example below lcSelect contains the SQL statement. How can I execute this statement using lcSelect?
>>
>>lcfile = "apdist"
>>lcCompany = "99"
>>
>>lcselect = "Select * from " + "d:\demo\pro73b\sampledata\" + ALLTRIM(lcfile) + ALLTRIM(lcCompany)
>
>BTW, use TEXT...ENDTEXT to create the string. It lets you create very large strings while keeping the entry of the select like you'd write it to run.
>
>
TEXT TO lcSelect TEXTMERGE NOSHOW
>SELECT * ;
> FROM d:\demo\pro73b\sampledata\<<alltrim(m.lcFile)>>
>ENDTEXT
Mike,
He needs to preprocess this to remove semicolons and make it appear as a single line command. ie:
lcSelect = Chrtran(m.lcSelect,Chr(9)+';'+Chr(13)+Chr(10),Space(1))
I'd instead do:
Select * from ("d:\demo\pro73b\sampledata\" + ALLTRIM(m.lcfile-m.lcCompany))
Cetin