Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record deleted after tableupdate
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00897403
Message ID:
00897484
Vues:
16
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform