Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Identity column
Message
 
To
13/10/1998 18:53:34
Scott Barker
Barker Systems Consulting Ltd.
North Vancouver, British Columbia, Canada
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00146437
Message ID:
00146447
Views:
22
>Hi there
>
>How do you retrieve the unique identifier sql server assigns to the
>record you just sent in with the tableupdate() funct from a remote view? ... seeing that it was my only unique indent ... I don't know how to get it back? ...
>
>I need to show this id to the user after they have pressed save.
>
>This is probably an easy question for someone in here!
>
>Thx for any quick help you can provide!
>
>Scott

Scott, REQUERY() your view after TABLEUPDATE. If you have more than 1 record in the view it would be a little more tricky, because you should also find the necessary record then.

HTH,
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro

"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison
Previous
Reply
Map
View

Click here to load this message in the networking platform