Tom,
Example: main database concomp, table customer External database rrbyw14, table customer CONNECT concomp SCONNECT rrbwy14 SATTACH customer AS rrbywcustomer INSERT INTO rrbywcustomer SELECT custid FROM customer UPDATE rrbwycustomer SET column = value WHERE condition DELETE ROWS FROM rrbywcustomer WHERE condition Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of TOM HART Sent: Monday, November 03, 2008 3:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Sconnect and Sattach How do I identify the sattached table. Do I 'insert into tablename(sattached table) or the alias name for the table. Tom Hart ----- Original Message ---- From: Emmitt Dove <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Monday, November 3, 2008 2:11:51 PM Subject: [RBASE-L] - RE: Sconnect and Sattach Tom, You can insert into, update and delete from tables that are SATTACHed just as if they were normal tables. They exist in your main database only logically, and then only as structures. The data continues to reside in the other database. R:BASE uses ODBC as the pipeline. Emmitt Dove Manager, DairyPak Business Systems Evergreen Packaging, Inc. [EMAIL PROTECTED] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of TOM HART Sent: Monday, November 03, 2008 2:40 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Sconnect and Sattach I am using the Sconnect and Sattach to update 2 databases as follows Both databases are identical Connect MYdatabase Sconnect Otherdatabase(leaving off entire string-I can Sconnect Sattach Mytable as Othertable projecting temp from othertable then updating Mytable this all works slick as can be but now how do I update in other direction? ??? project temp from Mytable then updating Othertable the Othertable is the sattached Mytable from the sconnected Mydatabase I guess my question is: is the sattached 'Othertable' the actual table or is it like a temp table. This is probably confusing but I want to update Mytable in the sattached database. Tom Hart
