You can pass that string as is by just delimiting it with either of the other two possible string delimiters in Fox:
SQLEXEC(lnHandle, [create user "usr" identified by "asd"...;])
or
SQLEXEC(lnHandle, 'create user "usr" identified by "asd"...;')
Or, you can use TEXT/ENDTEXT:
TEXT TO lcSQL NOSHOW TEXTMERGE PRETEXT 15
create user "usr" identified by "asd"...;
ENDTEXT
SQLEXEC(lnHandle, lcSQL)
HTH,
Chad
>I'm using VFP 9 with Oracle 10g. I have to pass to Sqlexec the following string
>
>create user "usr" identified by "asd"...; grant connect to "usr"
>
>How can I do it? What is the escape sequence for "?
>Is there a log for the commands I send to the server?
_________________________________
There are 2 types of people in the world: