Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SELECT command, longer than 255 characters
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00152131
Message ID:
00152587
Vues:
23
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.
Barbara Paltiel, Paltiel Inc.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform