how to insert record in between records of database file

[VPM1881]

Hi, I am working on project in which i need to read / write .mdb file.I am able to write data in the file but i am not able to write data in between two records.That is i need to insert some data lines in between the records in the file.

Can anybody tell me how to do it?I really stucked at this problem.

vaibhav

[muks]

Have you seen this discussion?

[muks]

Use an insert into

[jcarmody]

---

VPM1881 wrote:

[...] i need to insert some data lines in between the records in the file. 

---

I think you misunderstand something; a database table doesn't work the way a spreadsheet works.  You can order the records by any particular field in a query using ORDER BY.  If you want to edit the order that they've been entered you'll need to delete all elements and rewrite them in the order you want, but this is a silly thing to do as the order of data entry doesn't mean anything in a properly designed table.

[VPM1881 · Accepted solution]

Thank you
Actually it was problem with 8.5 version.
When i have installed 8.5.1 it got solved.

[jcarmody]

---

jcarmody wrote:

---

VPM1881 wrote:

[...] i need to insert some data lines in between the records in the file. 

---

I think you misunderstand something[...]

---

Now I think I misunderstand something.  Consider a spreadsheet having a number of rows and you want to insert a row in the middle.  What I do in MS Excel is right-click on the row below where I want to put the new data and select 'insert'.  This moves everything down and creates an empty row.  Is this what you were trying to do in a database table?  How'd you do that?

[yangs]

hi

Do you have some ideas to achieve this?