Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with a local view not updating the base table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Problem with a local view not updating the base table
Divers
Thread ID:
00243350
Message ID:
00243350
Vues:
51
I'm trying to insert a value into a local view but it's not working and not returning any errors.

The view is in a forms DE with NoDataOnLoad = .t., within a method on the form is the following code:

SELECT contact_by_id &&the local view
lcAbId = NewId("AddressBook") &&generates a new PK
thisform.CurId = lcAbId && store the PK in the form

** add a new record to the view
INSERT into contact_by_id ;
(ab_id, abstatus) values (lcAbId, .t.)

The code works correctly. If I look in the data session (it's private) after the code runs the ab_id field in the view has the correct value. I issue a tableupdate(.t., .t.), which returns .T. and close the form.

If I browse the base table the ab_id field is blank(?). The abstatus and any other fields contain the correct values.

I've checked everything I can think to check but I can't figure out why the 1 field won't update.

Any ideas?
Roi
'MCP' Visual FoxPro

In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform