Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How could you explicitly call stored proc
Message
 
To
06/06/2002 11:37:24
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00665497
Message ID:
00665595
Views:
20
This message has been marked as the solution to the initial question of the thread.
>Say x() exists as a stored proc, in a prg file (set proc to), fll function.
>How could you specify you want Stored proc one w/o default value usage or ADO ?
>This should be a simple thing but turned out to be a nightmare! TIA
>Cetin

Just an idea that can work.
Some testing required...
*assuming the dbc open and current and containing some proc
COPY PROCEDURES TO c:\test.prg
x=FILETOSTR("c:\test.prg")
x="DEFINE CLASS MyDBCclass AS SESSION"+CHR(13)+x+CHR(13)+"ENDDEFINE"
STRTOFILE(x,"c:\test.prg")
COMPILE c:\test.prg
SET PROCEDURE TO c:\test.prg addi
oMyDBCclass=CREATEOBJECT("MyDBCClass")
oMydbcclass.storeProcName()
HTH :-)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...


Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform