RE: Forcing a sequence in a table

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Victor Boris Arnold (anonymous_at_discussions.microsoft.com)
Date: 06/01/04 

Date: Tue, 1 Jun 2004 11:33:06 -0700

I don't think any of those suggestions will work for my
application. If row three was added last, but needs to be
listed before row two, none of these values will do the
trick.
>-----Original Message-----
>There is no point in worying about the physical
arrangement of data. Add a column that is timestamp,
autonumber, or some other scheme like max()+1 when
inserting new rows. Then use an Order By clause to sort
the result.
>.
>

Relevant Pages

  • Re: How top actually works
    ... So the next one shows that order by clause has affected the result set ... sort these N rows according to my order by clause. ... Ie. you are telling SQL Server ... This is much the same as with rownum in Oracle, ...
    (comp.databases.ms-sqlserver)
  • Re: Order of records in table as a result of a Query
    ... That is a whole world of difference in the meaning "not important": ... Why don't you simply export the results of your query? ... AL EXPORT in the same order as they exist in AL EXPORT SORT. ... ORDER BY clause is not being used at all. ...
    (microsoft.public.access.queries)
  • Re: Newbie: Counting the number of words in a Memo field
    ... If you do want to sort on the WordCount() column you can use the ordinal ... number of the column in the SELECT clause in the ORDER BY clause instead ... >>Dim inword As Boolean ' Is c inside a word? ...
    (microsoft.public.access.queries)
  • Re: Customizing sequence types
    ... This list should contain other instance objects and has to manage ... I need to sort the elements using this value. ... to check the presence of an element according to an attribute. ... inserting into the list as it takes advantage of and ensures that the ...
    (comp.lang.python)
  • Re: Repost - Help with code
    ... I tried your last suggestion - to put ... form are sorted and the form itself is set to sort, ... >>> I'm dubious of a nested Where clause in an OpenForm's WhereCondition. ... >>> IF NOT OpenArg is null THEN ...
    (microsoft.public.access.formscoding)