It sounds like you're trying to use it for something other than just numbering the rows in the order they are inserted into the database. It should not be used for anything else. If you want to order by col 2 or 3 or 4, you do that by other means (ORDER by queries, or other order by columns you can use independently). By far most of my tables start with an autonum column which I also use as an index or PK for the table. No other uses.
On Sun, Mar 18, 2012 at 3:01 PM, Michael J. Sinclair <[email protected]>wrote: > Hi All, > I have a table with a few thousand rows. The first column is an integer > and initially it has no data. That is the column I want to use to number my > rows. I want to put a 1 in the column for the row that has the lowest value > for the 2nd, 3rd and 4th columns. They all have data that is easy to sort > (date, time and filename). > > At the moment, what I am doing (which works just fine) is I declare a > cursor to go through the table, ordered by the date, time and filename, and > update the integer column with a number (.vcount +1). > > Is there a better way to do this? Should I be using a project command with > an order by clause and an autonumbered column? What is the fastest way to > autonumber a column based on the sort order of other columns? > > Mike > -- William Stacy, O.D. Please visit my website by clicking on : http://www.folsomeye.net
