>>>>You must TableUpdate CursorAdapter Alias, not TABLES from which it is created :-)
>>>>
>>>>* BeforeRowColumnChange and AfterRowColumnChange
>>>>IF NOT tableupdate(0,.t.,thisform.oCa.Alias)
>>>> AERROR(laError)
>>>> MessageBox(laError[1,2])
>>>>ENDIF
>>>>
>>>
>>>Actually, I had tried that but there may have been other issues at the time. I have now tried:
>>>
>>>tableupdate(0,.t.,thisform.oCA.alias)
>>>tableupdate(0,.t.,thisform.oCA.alias())
>>>tableupdate(0,.t.,'CA1')
>>>tableupdate(0,.t.,CA1)
>>>
>>>None of which work.
>>>
>>>:(
>>
>>The right syntax id:
>>tableupdate(0,.t.,thisform.oCA.alias)
>>CA has no method named ALIAS to call :-)
>>
>>What AERROR() said?
>
>I am puzzeled. The tableupdate does not produce an error. However the data is not saved even though I have confirmed that the method is firing. When I attempt to reload the CA by selecting a new value in the cboInteractiveChange I get an error that says
>"Cannot refresh CursorAdapter Table buffer for alias "CA1" contains uncommitted changes."
>
>- :-(
Are you sure that all fields are properly specified as updatable?
Here is a trick I use to test CA (and for some unknown reason I always end with it instead of starting with it):
in the command window:
o = newobject('myCAClass','myCa.lib')
o.CursorFill()
browse
make changes
?tableupdate(.t.,.t.)
?o.cursorrefresh()
Also examine your tables, if the changes were indeed saved.
If it's not broken, fix it until it is.
My Blog