Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How could you explicitly call stored proc
Message
From
07/06/2002 03:21:10
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00665497
Message ID:
00665802
Views:
15
>>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 :-)

Gerald,
I haven't tested yet too but bet it'd work and much more elegant than mine :) Thanks.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform