Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote views, Tableupdate and identity keys
Message
 
 
To
20/06/2011 00:27:03
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP2
Database:
MS SQL Server
Miscellaneous
Thread ID:
01515107
Message ID:
01515149
Views:
69
>>Actually, I just re-read Fabio's suggestion
>>Re: SPT, updatable cursor and last identity value Thread #1458392 Message #1459209
>>
>>I don't think I've tried that, but it does indeed sounds like a solution and I should have tried this instead of keeping the original code.
>
>I don't get why he is getting scope identity if the tableupdate fails?

He is using it only when tableupdate succeeds. Re-read the suggestion, he is checking the tableupdate status:

if tableupdate(.f.) &&.f. so we're updating only one record.
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