OraclewwDataset, insert and refresh

[applehouse]

HI,

I use OraclewwDataset together with a sequence to insert new records with an unique key. This works fine. However, after inserting the records are not ordered any longer in the grid. Only after doing a refresh are the records ordered again in the grid. Is there a way that after each insert the records stay ordered without doing a refresh?

Maybe there is an easy solution to this but unfortunately I'm not that experienced with SQL.

For example if I use the BDE to access the oracle table, the records stay ordered after inserting (and looking at the time it takes after inserting no rrefresh is used here), so I guess it must be possible with DOA as well.

Any help would be appreciated.

 

[Marco Kalter]

The TOracleDataSet does not have any capabilities to order newly inserted records. They stay in the position where they are inserted until the dataset is refreshed.

------------------
Marco Kalter
Allround Automations

 

[applehouse]

Thanks for the advice