Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote View Implicity Updating Base Table?
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00454924
Message ID:
00455174
Views:
28
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform