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:
00897484
Views:
15
Even if I replace a field with the same value it had in my app, the record doesn't get deleted. Do you have some kind of rule in your database that might be causing this?

You can surround code with < pre> and < /pre> (without the space after the < ) to save your indenting and add color coding.

>>> 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
Reply
Map
View

Click here to load this message in the networking platform