Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement