>>>>>I am having the same problem. I created the view in my database with
>>the
>>>option to send SQL updates with key and modified fields. Shouldn't this
>>>work without having to use the CURSORSETPROP?
>>>
>>>Yes. I have a fully working view with no coding at all, though I
>>generally
>>>use coding to do everything now.
>>
>>I usually find it easiest to start with the designer and move to codeing
>>when things get a little more complicated
>>
>I've tried that but got confused over what I had done in designer and what I hadn't. How do you keep track of the designer work, like what fields are updateable, etc. (aside from the Create View...SQL)? Maybe there's a way to get the designer 'setprop' code?
How about the READMETHOD method?
P.S. I found that part of my problem was that I had not marked the key field as updateable in the View Designer. It defaults to NO.