Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ODBC & Stored Procedures
Message
From
22/07/1999 11:12:56
Bob Lucas
The WordWare Agency
Alberta, Canada
 
 
To
22/07/1999 07:39:26
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:
00244743
Views:
13
>Are your examples calling SQL Server Stored Procs or VFP Sotored Procs? If VFP, what is the ABSSQL object doing with the incoming parameters?
>
>Guy

The example calls a SQL Server stored procedure. The object asbsql is a wrapper for sql passthrough calls. Notice it does not have a connection handle. that is because the object knows the connection handle so all I have to pass it is the sql string to execute and the cursor name to create. the object also does error handling.

The application this example is taken from uses no DBF's. The database container I use is strictly for remote views and the connection definition.

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!
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform