<HTML><FONT FACE=arial,helvetica><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2">Hi,<BR>
<BR>
This is true, but I don't think it really requires a SQL solution. <BR>
<BR>
Since RevDB supports buildling a database cursor (revdb_query), it doesn't make sense to me that it can't return a subset of rows. I can't even ask a cursor for the _current_ row without iterating through all of the columns. On the other hand, revdb_querylist returns rows- but always ALL of them. I can always manually trim the list afterwards, but this is also awfully inefficient in the case where I am forced to load 5,000 records and then trim them down to 50.<BR>
<BR>
Shouldn't there be a simple revdb_getrows() function to go with revdb_getcolumnxxx()? Certainly revdb can do something more efficient than forcing the scripter to iterate columns with a cursor. Imagine fetching rows 1000 to 1100 out of 2000 in a 20 column results. I would have to iterate over 1,000 records, and fetch each of 20 columns 100 times- that's 3,000 calls to revdb!<BR>
<BR>
Even if revdb couldn't do anything much more efficient internally (which I doubt), it would at least run much faster and save the scripter a lot of headaches.<BR>
<BR>
Has anyone had this same problem, or found a reasonable workaround?<BR>
<BR>
Regards,<BR>
Brian<BR>
<BR>
Regards,<BR>
Brian<BR>
<BR>
<BLOCKQUOTE CITE STYLE="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px" TYPE="CITE"></FONT><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2">Hi Brian,<BR>
<BR>
Unfortunately, ANSI-SQL doesn't have a native solution<BR>
for that: you get all the records that fall within the<BR>
conditions of the WHERE-clause.<BR>
<BR>
However, MySQL provides an extension to the standard<BR>
syntax - 'LIMIT' - which will do what you want. Eg:<BR>
SELECT cust_id, cust_name FROM customer WHERE<BR>
cust_id >= theCurrentId LIMIT 100<BR>
would get you the first 100 customers with an ID<BR>
higher than or equal to the one in theCurrentID.<BR>
<BR>
Other databases _may_ support the same syntax, or<BR>
provide their own similar extension. But as they say:<BR>
your mileage may vary...<BR>
<BR>
Hope this helped,<BR>
</BLOCKQUOTE></FONT><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2"><BR>
<BR>
</FONT><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2"></FONT></HTML>