Gossamer Forum
Home : Products : DBMan : Discussions :

Adding New Record Between Two Existing Records

Quote Reply
Adding New Record Between Two Existing Records
Can anyone here please tell me how do I add new record between two existing records in flat file database?
Example :

Record Line 1
Record Line 2

I need to add new record in between line 1 and line 2 instead of under line 2, please help, thanks.


Quote Reply
Re: Adding New Record Between Two Existing Records In reply to
This is not something that you really can, or should do. One of the basic concepts of database design is that the order of the records in the file does not matter. Besides, as soon as any record is modified, the order will change anyway.

If you really have to have the new record between the other two, I suggest you download the .db file, open it in a text editor (a good one that's made for programming), move the record and upload the edited file.

But if you require your records to be in a certain order, you should rethink your database structure.

JPD
http://www.jpdeni.com/dbman/