Mike,
I don't know for Oracle but on SQL server I use :
SQLcmd = "SELECT * FROM TABLE1 T1 " + ;
"WHERE T1.field1 = ?MyFoxVariable1 " + ;
" AND T1.field2 = ?MyFoxVariable2 "
and the odbc driver does the work for me ...
Important : don't use functions, only variables after he '?' !
Pascal.
>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?