General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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()
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