Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC & Stored Procedures
Message
From
22/07/1999 16:46:54
Bob Lucas
The WordWare Agency
Alberta, Canada
 
 
To
22/07/1999 16:28:57
Guy Pardoe
Pardoe Development Corporation
Peterborough, New Hampshire, United States
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00243624
Message ID:
00244994
Views:
13
I agree. The interesting thing is, if you have a default value (which could be a stored procedure) this default value code will get executed. As well, stored procedure code used as a trigger will also be executed when accessing the database from ODBC. These triggers and default functions (I use one to generate the next primary key) are, in essence, stored procedures.


>>>A VFP stored procedure should be called just like a subroutine because the DBC is in the call stack. In fact, DBC stored procs are just another procedure file!<<
>
>But VFP Stored procedures are not supported when accessing a VFP database through ODBC. I think that was what the original question was dealing with (unless I mis-understood something).
>
>Guy
Previous
Reply
Map
View

Click here to load this message in the networking platform