General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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?
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only