Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Joe-
>For testing (vfp7) I have a table (table buffered) with one char field and one integer field. The integer has a regular index. I create a view of this table, (the view is table buffered) and insert a record into the view.
>The view is updatable. I tableupdate the view after the insert. I then
>edit the same record (without a requery) (I change the char value) in the view and tableupdate again. The newly inserted view record is now marked as deleted. If I take the base table and remove the index from the integer field and repeat this process the record does not get marked deleted. What is going on?
This is the same issue we were talking about last week, right? Since it's related to a primary key, and since updates are done based on primary key, I imagine that updating the view, but not updating the table (since both are buffered, right) is causing the confusion.
I still think you need to resolve the issue of the table not updated before going on with inserting into the view.
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