Information générale
Catégorie:
Produits tierce partie
Titre:
TableUpdate() Problem with View and Its Table
Hi!
I am using VMP 4.0. I have a form where buffering is set to 3 for an updateable view and its underlying table--I am having problem with TableUpdate(). I have a command button in this form that inside its valid method I am calling a routine that posts changes to a batch of records in the updateable view. After the routine is executed, I try to commit the changes. The valid method looks like the one below:
PostChangetotheView()
IF !Thisform.UpdateBuffers()
IF ThisForm.RevertBuffers()
*post message to the user
ENDIF
ELSE
*success
ENDIF
My problem is that inside UpdateBuffers() the tableupdate() command returns a .F. for my updateable view and for its underlying base table--a "Record is in Use" error message appears when buffering is set to 3 for both. If I changed the buffering of the underlying table to 5, tableupdate() returned .t. for the view but for the table it returned a .f.--"Record in Use" error. Therefore, UpdateBuffers() still returns a .f..
This problem does not occur if the form is running locally but only if the form is running in the file server, and even when I am the ONLY user accessing the form and the application.
I wish to know what could be causing the problem here. I have some forms where the buffering is set to 3 for both a view and its underlying table, common in VMP4.0 design, but none like the error I explained is happening. Is there something I am missing here?
Thanks for any help,
Evelyn
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement