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