Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TABLEUPDATE(2,.T.) leaves records that are not updated
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00500580
Message ID:
00501449
Views:
39
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)
Previous
Reply
Map
View

Click here to load this message in the networking platform