Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
VFP + SQL Server 2005
Hi
I want to connect to SQL 2005 to retrieve data into VFP, but I'd like the cursor within VFP to be updatable within SQL. The issue is that I'd like the record locking/updating to be handled natively within SQL 2005, and as some of the tables have a large number of fields, the idea of using the UpdatableFieldList seems very long-winded when you could have 400-500 fields in said table??!?!
I like the idea of pass-through as I can run stored procedures from SQL 2005, and in reality, I'd prefer to keep as many of the SQL statements native to SQL 2005. VFP is only really used to tie the cursor fields to their respective fields on a form, and then call the update or revert procedure to save/discard any changes to the data.
Any ideas?
Regards
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