General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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.
This is the same issue. I posted this before the other message that included the example code. I figured it was much easier to understand with
an example.
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