Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
ODBC & Stored Procedures
Message
De
22/07/1999 11:12:56
Bob Lucas
The WordWare Agency
Alberta, Canada
 
 
À
22/07/1999 07:39:26
Guy Pardoe
Pardoe Development Corporation
Peterborough, New Hampshire, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00243624
Message ID:
00244743
Vues:
17
>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!
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform