Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
New record with pass through
Hallo all!
I am just learning to use VFP7 with an SQL server 2000.
I am pesently going through the book "Client/Server Applications with VFP and SQL Server" and I have a question about pass through querys.
When I make an update from the cursor to the server, It works fine when I do "CursorSetProp()" (UpdateNameList,UpdateFieldList) for the fields I want to change (2-3 fields).
BUT! If I append a new record to the cursor and set a value in just 2-3 fields, do I really have to use "CursorSetProp()" (UpdateNameList,UpdateFieldList) for ALL fields in the table on the server. The table contains 96 fields, and it will be a lot of code, just to append a new record. Are there not any shorter solution for this? I can do this if I make a remote view, but I want to use pass through, because I think I have better control and options then.
Does anyone have any answers and/or comments on this?
Thanks in advance
/Kjell
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