Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Buffering
Message
 
 
To
06/02/2007 17:44:29
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
01191514
Message ID:
01193206
Views:
15
>>>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform