Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updates Not Saving
Message
De
31/03/2009 14:58:54
Robert Dinsmore
Dinsmore & Associates, Inc.
Lexington, Kentucky, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Updates Not Saving
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01392464
Message ID:
01392464
Vues:
94
An application written some years ago suddenly stopped saving records on occassion.

A form that is used to add/change/delete records in a table is used to add a new record. When the Save button is clicked, a method is used (from a class) to update the table with the tableupdate() command. The form uses a view of the table. The tableupdate looks like this: x = tableupdate(0,.t.) - update the current record only, force update. The actual code is:

select &lcNaView
l_x =tableupdate(0,.t.)
if l_x = .f.
=aerror(laArry)
if alen(laArry,1) > 1
do form hmutferr with program(),laArry(1),laArry(2)
else
do form hmutferr with program(),laArry(1),""
endif
else
flush
endif

If the record does not get saved, it is apparent to the user because the new record does not appear in a grid which displays immediately after the save. Then if the user attempts to add it again, they get an error message that the record already exists.

Usually, they can get out of VFP, restart and add the record successfully.

This has really got me stumped. It doesn't happen all of the time. It has been working perfectly for a couple of years.
BTY - the databse is located on the server.

Any help would be appreciated...
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform