<HTML><FONT FACE=arial,helvetica><FONT COLOR="#000000" FACE="Geneva" FAMILY="SANSSERIF" SIZE="2">OK, I see where you are coming from. I agree that scripted solutions can be better than adding a lot of different functions to the API. I hadn't considered the usefullness of column functions for binary data. That is true.<BR>
<BR>
For the record, the only reason I am so concerned about not scripting this is because my product is web-based, and performance is a big deal. For a lot of apps, I'd have no problem scripting the solution.<BR>
<BR>
If you really will add the currentrow() functionality, may I suggest that there be a parameter for how many rows to fetch? It just makes for nicer code to write something like:<BR>
<BR>
put revdb_fetchrows(theCursor, tab, 50) into theRows<BR>
<BR>
than<BR>
<BR>
repeat 50<BR>
put revdb_currentrow(theCursor, tab)&cr after theRows<BR>
revdb_movenext(theCursor)<BR>
end repeat<BR>
<BR>
At this point I'm just making suggestions for smaller scripts... those two probably aren't far apart in terms of performance.<BR>
<BR>
It would also be useful to allow an optional parameter to revdb_movenext(), so that one could hop, say, 50 rows.<BR>
<BR>
Just trying to eliminate the repeat loops from my code now, it's great for the psyche =).<BR>
<BR>
Of course if you decide against it, I can benchmark some of the scripted solutions and see how they stack up.<BR>
<BR>
Brian<BR>
<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">OK sure I can add revdb_currentrow. It's just as an external/engine<BR>
developer the first question you have to ask yourself is -can it be<BR>
scripted?- The cool thing about revdb_columnbynumber is that it can also<BR>
be used to access binary data..which is the sort of thing you want to<BR>
access column by column. In addition returning data as tab or comma<BR>
delimited requires that you parse the data anyhow to access each<BR>
individual column.<BR>
<BR>
Even revdb_querylist is a conveniance, and something that can probably be<BR>
implemented at the script library level.>><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>