Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stored Procedure Good/Bad? How?
Message
From
12/01/2001 13:27:06
 
 
To
12/01/2001 13:15:20
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00463078
Message ID:
00463094
Views:
15
Hi John,

> I'm confused...is your back-end (server) database VFP?

Yes the database is an '.DBC'

> Anyway, you call the stored proc by replacing "mysqlstatement" below with the stored proc name.

I Tried the following:
nconhandle = sqlExec(nhandle, myprocedure(dweek_act), mycursor')
I get 'File myprocedure.prg does not exist'
nconhandle = sqlExec(nhandle, 'myprocedure(dweek_act)', mycursor')
Here nconhandle = -1

If in developement I type ?myprocedure(dweek_act) in the command window with the database open, I get a cursor. How do I translate that into my program?

TIA
Mike
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform