Upgrade to VFP 7 and you can use
TEXT TO VarName
If it's not an option give me your email addres and I'll send you my function that allows to do the same in VFP 6.
>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?
--sb--