Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TABLEUPDATE(2,.T.) leaves records that are not updated
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00500580
Message ID:
00501449
Vues:
33
Gentlemen,

Yes, it's SPT, I just referred to it as a view.

llRetval=TABLEUPDATE(2,.T.,"DetailView",Errors) returns .T., which I assume means everything was updated. It also means that my error routine, which relies on IF llRetval=.F. won't fire.

To Hiten Kishor: It's true, Foxpro will continue processing after an error if TABLEUPDATE(2) is issued, but it will not return .T. and it will propably record the error if cError variable is specified.

Anyway, I'm greatful for your involvement and the workaround.

*Snip
>>Yes, if that was what he was doing. Somehow, I don't think that was the case. I was real confused because at one point he said he was using SPT [first reply to Hiten Kishor].
>
>As I understood it, he used SPT to get the data.
>Made an updatable cursor with Table buffering.
>Made changes.
>Issued TableUpdate(2)
>Then was trying to handle the failed updates.
>I'd suggested looping and issuing the singleton TableUpdate(1) or TableRevert(.F.) on each hit as needed.
>
>Otherwise, endless loop!
Peter Pirker


Whosoever shall not fall by the sword or by famine, shall fall by pestilence, so why bother shaving?

(Woody Allen)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform