>Hi Chris
>
>Just a SWAG, haven't tested this but ... when you create a view with NODATA it's empty. The record pointer should be on EOF(), now when you APPEND a blank record and do a BROWSE the record pointer will move to 1. If your buffermode for the view is 3 this will fire a implicite TableUpdate().
>
>Change the buffermode to 5 and look if it happens again.
It does not happen when I set the buffering mode to 5, but the behavior still seems strange. After the APPEND BLANK, everything is OK, but the BROWSE triggers the update. If after the APPEND BLANK I replace the primary key with a duplicate value and then BROWSE, I get an error message indicating that I have a duplicate value.
I think the key here is that it does not happen after an APPEND BLANK or a REPLACE, but when I issue a BROWSE with BUFFERING set to 3.
Chris McCandless
Red Sky Software