Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Thanks for the great answer.
Is there a way that a remote view made in VFP can access/run a Stored Procedure?
The only reason I ask is because multi-user development in SQL is not a problem, compared to a source-controlled DBC from FoxPro. Moving to SQL was going to help us out that way, but not if views have to be still made in VFP.
Dustin
>As others have said, the work is done on the SQL Server box. Here's why.
>
>Remote views are a user-friendly (sometimes) wrapper for SQL pass-thru. A query is built using the information stored in the DBC (SQL statement, parameters, etc.) and that is sent to the server for processing. The same thing can be done manually by:
>
>
Create a SQL Select statement
>Create a connection to SQL Server using SQLConnect() or SQLStringConnect()
>Get a result set using SQLExec() and the SQL statement
>Make the result set read/write
>Make your changes
>Process the result set to determine which records have changed
>Process the changed records to determine which fields have changed
>Create a SQL Update statement using the new field values
>Send the SQL statement to SQL Server using SQLExec()
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement