Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Creating SQL to pass to SQL Server or Oracle
Message
From
09/10/2001 17:12:11
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Creating SQL to pass to SQL Server or Oracle
Miscellaneous
Thread ID:
00566215
Message ID:
00566215
Views:
36
I am connecting to an Oracle back-end and have to create my SQL as a string and pass that string to Oracle. That makes my code look like this:

SQLcmd = "SELECT * FROM TABLE1 T1 " + ;
"WHERE T1.field1 = " + MyFoxVariable1 + ;
" AND T1.field2 = " + MyFoxVariable2
and so on...

I'd rather be able to use TEXT...ENDTEXT or something to look like:
TEXT
SELECT * FROM TABEL1 T1
WHERE T1.field1 = <>
AND T1.field2 = <>
ENDTEXT

The problem is that the TEXT goes to the printer or a text file.
Does anyone have a better idea?
Next
Reply
Map
View

Click here to load this message in the networking platform