<html>
Might it have something to do with SQL not really having a native concept
of "rows"? SQL is a Query system not a database
management system. SQL can be used against an "Object Oriented"
database system even, which is somewhat different than the
column,row,table paradigm we are used to when we generally talk about
databases. SQL is concerned about querying a database not implementing
it. It is up to the development environment you are in to do that
(REVdb?). <br><br>
At least that is how I have understood SQL in the past and up until
someone enlightens me. BTW I am not really "in the know" about
"real" SQL! I have mostly used special "flavors" like
FoxPro. Definitely not the real thing!<br><br>
djl<br><br>
At 12:45 PM 1/27/03 -0500, you wrote:<br>
<blockquote type=cite class=cite cite><font face="arial" size=2>Hi,<br><br>
This is what I'm using... and it works ok.<br><br>
I guess it just seems to me that there should be a way to fetch a
particular row from the results of a query without having to process the
entire record set as text in MetaTalk. <br><br>
I'm just confounded by the cursor API, but maybe I'm missing something.
Why would I want to be able to fetch columns from the cursor but never
rows?<br><br>
Say I have a database cursor, and all I want to do is plunk the first 10
records, with 10 fields each, into a form. I have to make 10 calls to
RevDB to fetch the columns, and then I have to merge 10 columns of text
to make 10 rows. ECK! I know I can use revdb_querylist() and script
around this, but then again... I want to use a database cursor!<br><br>
I just don't follow the logic- why fetch columns but not rows?<br><br>
Brian<br><br>
<blockquote type=cite class=cite cite> get
revdb_querylist(return,comma,tConnectID,tQuery)<br>
put line 1 to 100 of it into tFirstResults<br><br>
It ought to do the trick "when you want to obtain the<br>
data for use but don\u2019t need to retain a reference to<br>
the records that the data came from."<br><br>
Hope this helped,</blockquote><br>
</blockquote>
<x-sigsep><p></x-sigsep>
======================<br>
|| Dave
LeYanna
||<br>
|| Director
IS
||<br>
|| Right to Life of Michigan ||<br>
======================</font></html>