Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate() Problem with View and Its Table
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Produits tierce partie
Divers
Thread ID:
00606578
Message ID:
00608372
Vues:
19
I am not familiar with how VMP works, but what happens if the table is not buffered?

>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
Mark McCasland
Midlothian, TX USA
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform