Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Possible to call stored proc from code?
Message
From
11/03/2011 01:56:52
 
 
To
10/03/2011 22:29:23
Mike Yearwood
Toronto, Ontario, Canada
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01503189
Message ID:
01503301
Views:
57
>>Is it possible to call a stored procedure in a DBC from VFP code?
>>
>>I've searched the web and every hit I followed shows how to call a stored procedure in a "remote database" (not a DBC, but something like SQLServer) from VFP code. Either that or how to call a stored procedure in a VFP DBC from non-VFP code (like VB).
>>
>>TIA
>
>If you need a procedure to be called from the DBC or elsewhere, it belongs as a separate function, likely built into the exe, and not the DBC.

I agree 100% if there is at least always a biz layer (in exe or com-dll) written in vfp through which to call.
But there might be the case where the DB-layer is only accessed via OLEDB by clients in other language -
while calling vfp code in prg is possible as well, arguments from installation/set path/set prog areas gain strength IMHO.

YMMV

thomas
Previous
Reply
Map
View

Click here to load this message in the networking platform