Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return new keyfield value when insert record to view
Message
From
22/09/2006 11:56:50
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
22/09/2006 11:01:52
Denis Gavrikov
Moscow, Russia
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Return new keyfield value when insert record to view
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156470
Message ID:
01156505
Views:
20
>I have a localview. The keyfield generated by stored procedure. I insert record to localview and do Taleupdate(0,.t.) - how may I know new value of keyfield what was generated?
>
>Thanks
>Denis.

Your stored procedure might return it to you.
Denis,
IMHO this is one of the reasons why you shouldn't use a key that can only be generated at backend.
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform