Marc, Time permitting, I will try to give you an example. Or if you wish, send me your table privately.
Jan -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 25 Mar 2010 11:49:38 -0500 Subject: [RBASE-L] - Re: Merge 2 rows into one Jan Yuk, Cursors scare me and I try to avoid them as much as possible. I was hoping for a Project table that combined the notes to together. Thanks Marc From: jan johansen Sent: Thursday, March 25, 2010 10:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Merge 2 rows into one Marc, I've be scratching my head on this one. I don't think there is an eloquent way to do this. I think you just need to brute force this with a cursor. Run the cursor through your rows using the date. Concatenate the notes together until the next date. Insert the new combined note into the new table. Jan -----Original Message----- From: "MDRD" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 25 Mar 2010 09:55:56 -0500 Subject: [RBASE-L] - Merge 2 rows into one Hi I have a table that has TrDate,TrNotes (note field), VerNum (autonum) and a few other column that may have 1,2 or 3 rows per day We had 2-3 notes per day on some days because we went over the 4k limit. Now I want to merge or combine those notes to a new Table that has a TxDate, TxNotes (Varchar column) ... Is there an easy way to do this in one command? It seems so easy when I look at it but when I start to write the command on paper my head starts spinning. Thanks for any suggestion Marc
