Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Buffering
Message
 
 
À
06/02/2007 17:44:29
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01191514
Message ID:
01193206
Vues:
16
>>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform