Danijel (nice picture, by the way)

I've found it's useful from a debugging standpoint to divide my strings into FIELDS, TABLES, FILTER and ORDER clauses, so the SQL looks like

SELECT &cFields from &cTables;
WHERE &cFilter into cursor MyCursor ordered by &cOrder

Much simpler to handle it all.

HTH
Barbara

>>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.