Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate() Problem with View and Its Table
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Titre:
TableUpdate() Problem with View and Its Table
Divers
Thread ID:
00606578
Message ID:
00606578
Vues:
47
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
Fil
Voir

Click here to load this message in the networking platform