General information
Category:
Coding, syntax & commands
Title:
Creating SQL to pass to SQL Server or Oracle
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only