I doubt it. The SQL standard says that the order of data storage or retrieval is not necessarily in the order of entry.
The only way you know the sequence of entry is with an autonumber column. It is your responsibility to request the data ordered the way you want it. Dennis ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of jan johansen Sent: Thursday, October 30, 2008 3:47 PM To: RBASE-L Mailing List 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
