General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2003 Server
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only