Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Record deleted after tableupdate
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00897403
Message ID:
00897478
Views:
15
>> This has to be a bug in your code. I do this all the time.

The deleted record only occurs when you replace a field with the same value it had before the tableupdate is issued. The reason I don't think it is a bug in my code is that you can issue a browse immediatly before the tableupdate and the record is there. Then immediatly after the tableupdate issue another browse and the record is still there, but it is marked for deletion. See code below. (BTW, how do I get the code to appear indented in these posts?)


if app_o.do_form_modal( this.edit_form )
select (this.recordsource)
if cursorgetprop( [Buffering] ) > 1
set deleted off
application.Visible = .t.
browse
tableupdate(0, .t. )
browse
else
select (this.recordsource)
tablerevert( .f. )
endif
endif
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform