Ben Thanks, I thought the same thing but I was hoping for a different solution. Buddy -----Original Message----- From: Ben Johansen [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 03, 2001 2:32 PM To: [EMAIL PROTECTED] Subject: RE: Tango Hi Buddy, For the most part each tango action that talks to the database is a one-to-one situation, where 1 tango action is usually 1 sql statement. in a direct-DBMS you could do the following "insert into table1 (column) select (column) from table2 where ..." and this would insert however many rows that the where clause return into table1 I have found no way at this point to tie a Tango array to a single insert. for the most part you will need to create a loop on the array with inserts inside the loop. Ben Johansen -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Walker, Buddy Sent: Monday, July 02, 2001 11:58 AM To: [EMAIL PROTECTED] Subject: R:Tango I'm using R:Tango 2k, RBase 6.5++, Windows NT 4.0 SP6, and Oterro 2k Is there a way using Direct DBMS of inserting 5 rows in one action or do I need to run Direct DBMS 5 times (once for each insert) Thanks Buddy
