Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Return new keyfield value when insert record to view
Message
From
23/09/2006 16:30:48
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
22/09/2006 14:37:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01156470
Message ID:
01156729
Views:
20
Denis,
Still my original post stands:
Database1 - Table Customers1 - key generated by database and returns new keyvalue
Database2 - Table Customers2 - key generated by database and returns new keyvalue
Cetin

>Ok. I try to explain.
>Database1 - Table Customers1 - key generated by database
>Database2 - Table Customers2 - key generated by database
>
>Database3 - Localview for Customers1, Localview for Customers2
>
>Now in Database3!Customers1 I need insert record and write to log file - id of new record
>
>I must to say.. this is try of extend existing application with some replication feature.. where 3 company replcated data ... and middle database is solution
>
>Thanks
>Denis
>
>
>
>>I don't understand the case. If it is in a single database or from multiple databases or no database at all you could have a key like GUID that can be generated before inserting.
>>As I said your stored proc could return it to you.
>>Cetin
>>
>>>Hi Cetin,
>>>Yes, its if the table stored in database..
>>>I have a case.. when In a database stored localviews from diffrent databases. (I try to develop some replication engine). Is there chance to get this key value?
>>>
>>>Thank you.
>>>
>>>
>>>>>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
Reply
Map
View

Click here to load this message in the networking platform