I am using SQL pass through, VFP 8 with SQL Server.
I have two questions:
1.To make a result set/cursor updatable, you have to manually list all fields of the table (CURSORSETPROP("UpdateNameList"...). To me it seems like a lot of work.
I was wondering, is there a method/function to build the expression automatically for any table?
2. After user changes the data, what is the "recommended" way of sending the changes back to the SQL Server: a) using tableupdate() b) building UPDATE expressing and sending it with SQLEXEC?
Thank you in advance for any suggestions.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham