@LarryKillen: "I have a table where records are assigned DateTimes when written.  I would 
like to be able to select a given number of records that were added after a 
given DateTime.  Is the possible?
pseudo code-
select next 10000 records added
where DateTimeAdded > '5/25/2005 12:30 PM'
TIA "
    @oleekerhovd: "query.sql.clear;
query.sql.add('SELECT aDatefield');
query.sql.add('FROM aTable');
query.sql.add('WHERE aDatefield >');
query.sql.add(':pDate');
query.parambyname('pDate').value:=anydate;
query.active:=true;
Not sure if it works, but it's a statingpoint :)
Regards,
Ole"
    @LarryKillen: "You missed my question.  I want to be able to return exactly 10,000 records 
(in my case chickens) that were added after given time.
"Ole" <email_address> wrote in message 
news:<email_address>
<quote>"
    @wniddery: "<quote>
When asking these questions you aleays need to tell us which database you 
are using, then solution will be different in each case. If using Interbase 
6.5 or later, you can use ROWS to get what you want:
select * from table
where DateTimeAdded > '5/25/2005 12:30 PM'
ROWS 20000 to 30000
Wayne Niddery - Logic Fundamentals, Inc. (<url>
RADBooks: <url>
"The legitimate powers of government extend to such acts only as are
injurious to others. But it does me no injury for my neighbor to say
there are twenty gods, or no God. It neither picks my pocket nor breaks
my leg." � Thomas Jefferson "
    @aceallanREMOVEME: "<quote>
Interbase
When asked in borland.public.delphi.database.sqlserver, I believe the
database is an SQL Server! ;-)
To Larry: Perhaps using the "SELECT TOP 10000 * FROM chickens... etc etc"
can do you good?
/Allan"
    @wniddery: "<quote>
No. Note the plural - "sqlservers", not 'sqlserver". This group is not 
specifically for MS SQL, it is for *SQL Servers* - that includes Interbase, 
MS SQL, Oracle, DB2, etc.
Wayne Niddery - Logic Fundamentals, Inc. (<url>
RADBooks: <url>
�It is error alone which needs the support of government. Truth can
stand by itself.� - Thomas Jefferson "
    @lotemlotad: "I blame MS for chosing a generic name for there own product.
I don't see OSQL or BSQL. (well i do see MySql but that come after).
news:429aa68d$<email_address>
<quote>"
{'source': 'USENET', 'other_information': '{"reply_count": 6, "forum_name": "borland.public.delphi.database.sqlservers.20141118.mbox"}', 'file': 'data/output/usenet-borland.public.parquet'}