General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only