Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table buffer error
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00212495
Message ID:
00212689
Views:
25
Nick, maybe I'm the one confused, but the 'sendupdate' property sets the view so it will update its base tables. To actually save the data you need to use TableUpdate() after each edit, and before you requery or move the record pointer.

HTH
Barbara


>I have a view and a table in my dataenviroment. My view (lv_subpay) is based on my table (sub_payment). On my form I have a add button that inserts new record into my table sub_payments and I also have a button edit that allows user to change the contents of the grid base on my view lv_subpay. When ever I make chnages to my grid and do sendupdate, and then requery my view I get the following message:
>
>Table buffer for alias "name" contains uncommitted changes (Error 1545)
>
>I do have my buffermode as pessimistic and datasession as private.
>
>here is my code for edit button:
>
> case nAnswer = 6
> cursorsetprop('sendupdates', .t.,'lv_subpay')
> lc_subkey = .a
> requery('lv_subpay')
> .hldcount = reccount('lv_subpay')
> .rec_view && determines if view has rec and set ctrls
>
>Has anyone run into this problem?
>
>thanks
>Nick
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform