I can say I have done all of these things. I have not tried this exact situation.
1. I know that the triggers work from Tango through Oterro. 2. I know I can read a 3rd party database connected via the 3rd party driver to an R:base database which is then accessed through Oterro from a Tango app. I have not tried connecting an R:base database to an R:base database through Oterro, but I don't see any reason why it wouldn't work. It should work the same as the 3rd party database does. If I get a chance, I will try setting this up, but I am sure it will work. Troy ===== Original Message from [EMAIL PROTECTED] at 7/19/02 3:34 pm >Tom, > >The external app does an insert to a transaction table in A that fires a >trigger (being handled by Oterro) to process the transaction and post it to >an inventory table. This fires a trigger on the inventory table in A that >wants to post an audit in database B. My question has to do with the >problem of getting from A to B if the external app knows nothing of >B. Will Oterro be able to make the connection and do the insert? > >Troy says it will work. I sure hope he's right!!! > >Emmitt > > >>You wrote: >>>Now, the question: In this case how can we establish a connection >>>between the Oterro driver (which is processing the first trigger caused >>>by the insert to the transaction table in Database A) and Database B so >>>that the second trigger (caused by the first trigger's update of an >>>inventory table in Database A) can write the audit record into Database B? >> >>Is Oterro processing the first trigger or is the database engine? >>Won't the second trigger be automatically "fired" by the action >>of the first? >> >> >>Warmest regards, >> >> >>Tom Grimshaw >>coy: Just For You Software >>tel: 612 9552 3311 >>fax: 612 9566 2164 >>mobile: 0414 675 903 >> >>post: PO Box 470 Glebe NSW 2037 Australia >>street: 3/66 Wentworth Park Rd Glebe NSW 2037 >> >>email: [EMAIL PROTECTED] >>web: www.just4usoftware.com.au >> >>"... the control of impulse -- is the first principle of civilization."-- >>Will Durant, >>Pulitzer Prize winning philosopher, writer and historian >> >>the most needed product in the world can be found at >>www.thewaytohappiness.org >> >>This email and any files transmitted with it are confidential to the >>intended recipient and may be privileged. If you have received this email >>inadvertently or you are not the intended recipient, you may not >>disseminate, distribute, copy or in any way rely on it. Further, you >>should notify the sender immediately and delete the email from your >>computer. Whilst we have taken precautions to alert us to the presence of >>computer viruses, we cannot guarantee that this email and any files >>transmitted with it are free from such viruses. >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >Emmitt Dove >Manager, DairyPak Business Systems >Blue Ridge Paper Products, Inc. >40 Lindeman Drive >Trumbull, CT 06611 >(203) 673-2231 >[EMAIL PROTECTED] >[EMAIL PROTECTED] > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
