>Does anybody know how to execute a SELECT sentence longer than 255 characters from EXE application.
>
>I allow my users to pick a fields from list and then I make a SELECT sentence (something like a query maker )
>
>This is working just fine from VFP development
>
>SET TEXTMERGE TO myPrg
>// some select syntax
>SET TEXTMERGE TO
>COMPILE myPrg
>DO (myPrg)
>
>but from executable, this feature is not available, does anybody have some idea how to solve this problem
>
SQL select can go up to 2000+ characters, but you should probably build up a text-string variable instead of merging and compiling a .prg. It will perform better as well. Ex.:
lcSel = "SELECT "
lcSel = lcSel + "SomeFields" + " FROM "
lcSel = lcSel + "SomeTables" + " WHERE "
lcSel = lcSel + "Condition"
&lcSel
I do it that way and it works great.
Danijel