Reg storage and reterival of records

[vidyut]

hai,

if store n number of records from a visual basic grid to oracle vai a ADODB recordset, while the next time i reterive the data the records get sorted alphabetically i want the records to get reterived in the same order as i stored. please help in this regards

thanks and regards
karthee

 

[karluk]

The only way to guarantee that records will be retrieved in a specific order is to use a where clause in your select. Depending on how the data was ordered at the time of insert it may, or may not, be possible to create a where clause that recreates the original order.

If you can't easily reconstruct the insert order you will probably have to add a sequence number column to your table. The sequence number can be assigned at the time of insert and used for sorting the data in the select.

 

[karluk]

Sorry for my mental lapse. Of course I meant "order by clause" instead of "where clause in the above post.