Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Alan,
If you have both the table and the view buffered you have to do a tableupdate() on both. The best way to do this is to buffer your view and leave the table itself unbuffered. Then the tableupate on the view will update the actual table.
HTH
Jeff
>Hello,
>I working with a Local View for the first time and I'm running into a problem with the update. After I issue my TableUpdate() the new record seem to be there. I can recall it and edit it. When I exit the application, then go back in, it's gone! I'm using VFP 6.0 SP3. I have both the table and the view set-up ad 3-Optimistic Row Buffering. I've tried it with 5-Optimistic Table Buffering also. It seems that the View creates a temporary file, but it is never written back to the table. I have a primary key and all of the fields are marked for update in the View designer.
>
>What am I doing wrong?
>TIA
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement