Re: Strange problem

From: Jeremy Collins (jd.collins_at_ntlworld-not.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 15:54:13 +0100

jason wrote:

> Why when I call the last procedure does it not position itself on the last record in the table, in my case the record with an ArchiveID=150??

If you want to /guarantee/ a particular order, use a TADODataset,
with an ORDER BY clause in the SQL statement. Accept no
substitiutes ;-) 

-- 
jc
Remove the -not from email

Relevant Pages

  • RE: Queries returning with missing info (plus asks query question
    ... Let’s start with the simple query first. ... are aggregate functions, but not reserved words. ... what is at the front of the SQL statement. ... Parameter clause at the top. ...
    (microsoft.public.access.queries)
  • Re: formula help please
    ... primary and foreign keys are essentials in solving such problems. ... each of the tables are related to each other with each SQL statement. ... engine like Oracle), the program adds additional lines to the actual ... WHERE clause that describes how the tables are to be linked together. ...
    (comp.databases.oracle.misc)
  • Re: query based on form
    ... Typically it's only the WHERE clause of the query that changes so you can build that dynamically, patch it into the SQL statement, and assign it to the SQL property of the QueryDef you use for export. ... they can choose one Sales Rep, all cities, all states, all counties, just one type of business and one renewal month. ...
    (microsoft.public.access.queries)
  • Re: Using SQL in Sub to fill box on mouseclick
    ... Your SQL statement is incorrect. ... The WHERE clause comes before the GROUP BY clause. ... > filled with a query telling me which people are scheduled to work a shift. ... > Private Sub Ctl8a_4pb_Click ...
    (microsoft.public.access.formscoding)
  • Re: WHERE clause question
    ... Carl Imthurn wrote: ... > Here's the WHERE clause of my SQL statement: ... I modified the WHERE clause as follows, ran it, and went ... How unique is the ProcedureID data in relation to the entire table? ...
    (microsoft.public.sqlserver.programming)