Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help calling an Oracle function
Message
From
28/02/2000 09:12:58
 
 
To
28/02/2000 08:55:39
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00338265
Message ID:
00338368
Views:
14
The syntax ? indicates that the variable is a "bind variable"
see the oracle documentation for info on this it translates
to something like after the odbc driver gets its hands on it.


EXECUTE pwadm.PSINSRT(:charvar1,:charvar2,:datevar1);


Now that I think about it it may not be necessary but it has an advantage
because the oracle optimizer will not need to reparse the statement each time it
is called so it could be usefull in the case when you are calling the statement repeatedly
or often.

charvar1=""
charvar2=""
datevar=date()

lcSQL="{Call pwadm.PSINSRT(charvar1,charvar2,datevar1) }"

Should work also now that I think about it...
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform