Jan, Doing what you want would violate SQL standards. ALL table data MUST be considered as unordered. That is the reas for the ORDER BY syntax.
Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 ________________________________ From: jan johansen <[EMAIL PROTECTED]> To: RBASE-L Mailing List <[email protected]> Sent: Thursday, October 30, 2008 3:47:04 PM Subject: [RBASE-L] - RE: INSERT Emmitt, Thanks. I was coming to the same conclusion. Proved it to myself by just inserting in the database explorer. When you edit again the inserted values are at the end. Just had always assumed you could insert a row in the middle of the dataset. Kind of like altering the table you can insert a column at a given position. Maybe for v9? Jan -----Original Message----- From: "Emmitt Dove" <[EMAIL PROTECTED]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 30 Oct 2008 16:41:34 -0400 Subject: [RBASE-L] - RE: INSERT Jan, R:BASE is always going to insert the new row at the end of the table. To accomplish what you describe you'd need an ordering column that you control, and after your insert you'd have to renumber accordingly. 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] -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Thursday, October 30, 2008 4:32 PM To: RBASE-L Mailing List Subject: [RBASE-L] - INSERT OK, Probably doing this wrong. I have a scrolling region. I have an Add button with the command PROPERTY TABLE mytable INSERT According to the help it says that it inserts a new empty row at the current position in the dataset. So if I thought if I have 6 items in the scrolling region, move to postion 3, press add, do my stuff and save that if I looked at the raw data my new row would be in position 4. But the new data seems to be showing up in position 7. Thoughts? Using 7.6.4.30919. Jan
