Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sqlexec with oracle
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
01147496
Message ID:
01147553
Views:
11
This message has been marked as the solution to the initial question of the thread.
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:
    Those who need closure
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform