Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Check out this thread... 680753
I found out what was causing it but really don't know why.
The first message in that thread has runnable code.
>What is the Primary Key of the table/view?
>
>>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?
Précédent
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