Re: Re[2]: ROWID Question - ADDITION/CORRECTION

Of course, if your users insert massive quantities of data, you'll have to alter your index to cluster quite often... ciao, Marco ____________________________________________________________________________ rem radioterapia, which I immeritately manage, seldom agrees with what I say marco greco (Catania, Italy) Work: marcog@ctonline.it rem radioterapia 39 95 447828 fax 446558 (was mar.greco@agora.stm.it) Achea 39 95 503117 --- On Fri, 08 Nov 1996 13:42:36 MST Jack Parker <jparker@boi.hp.com> wrote: > > There are no SELECTs in formcode that I am aware of. The user enter > his critieria into the form and hits escape. We are talking formcode > here, not 4GL. Am I missing something? > > Thanks, > Tim No you're not. Formcode retrieves in the order that things exist in the table. The only way to get them sorted in a particular order is to have them written to the table in that order. You can accomplish this with an ALTER INDEX foo TO CLUSTER where foo is an index on the columns you would like ordered. Of course I have never tried this - but it stands to reason.... cheers j. ________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@boi.hp.com Currently on loan to PLD/PE ________________________________________________________________________ Outside of a dog a book is a man's best friend. Inside of a dog it's too dark to read. (Groucho Marx) ________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. ________________________________________________________________________ -----------------End of Original Message-----------------