Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert-update-replace-update doesn't work
Message
 
 
To
24/10/2016 13:16:25
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
MS SQL Server
Virtual environment:
VirtualBox
Miscellaneous
Thread ID:
01642269
Message ID:
01642293
Views:
51
>>What happens if you only use ONE TableUpdate() at the end, and not in the middle?
>
>Yes, that would be the obvious fix.
>
>I don't really need a fix - this bit of code was a one-time conversion of a list from a .csv file, and now it's done and forgotten. I was just curious about the causes.
>
>So, to answer the others - no, I didn't check the return value from either tableupdate(), didn't catch errors, didn't try to fudge the code to make it work right. Had just enough time to see that it works, at least the second time - and then left someone else to run it the second time 'cause I had to drive to the airport.
>
>I'm interested in the cause for the sake of such things in the future. This was copied from another similar routine, just replaced the field names and didn't touch the logic much, so I may forget this and copy from the same place some time next year. And when it comes to that I'd like to know what's wrong in advance, and set it right before I start pulling the remainders of my hair :).

Well, I'd say - fix that bad pattern and use what was suggested in this thread.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform