Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problem with a local view not updating the base table
Message
De
19/07/1999 19:17:17
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00243350
Message ID:
00243356
Vues:
28
>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?

Did you use the view builder? If you did make sure that field is checked to update.

HTH

Dan
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform