Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro substitution and evaluate - which to use
Message
 
To
20/07/2007 13:25:10
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01241954
Message ID:
01242435
Views:
20
>>>I find it much easier to read code that contains the actual SQL command than code that builds a string and executes it.
>>
>>Tamar,
>>what is the difference (for reading the code) between these:
>>
>>TEXT TO lcSQL NOSHOW PRETEXT 15 TEXTMERGE
>>     SELECT <<aLine[1]>> AS <<BlaBla>>
>>           FROM ....
>>ENDTEXT
>>&lcSQL
>>
>>
>>and this:
>>
>>SELECT (aLine[1]) AS (BlaBla)
>>       FROM ....
>>
>>
>
>In the first case, I have to stop and figure out that a query is being built on the fly, then executed. The second case is obvious. But that's me. YMMV.
>
>Tamar


:-)
Agree,
Like Russians says: "On taste and color there are no friends". I hope I translated it right :-) But Naomi always can show the errors :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform