Checking EOF and BOF

[vasanthgnb]

Is there any ODBC API to check the EOF and BOF conditions without scrolling the cursor.

 

[Tucker]

Here's a Vbscript / asp example:

<%

dim rcset
set rcset = Server.CreateObject(&quot;ADODB.recordset&quot
rcset.open &quot;select * from employee&quot;, &quot;DSN=employee&quot;

do while not rcset.eof
response.write &quot;<br>&quot;
response.write rcset(&quot;ID&quot &amp; &quot; &quot;
response.write rcset(&quot;last&quot &amp; &quot; &quot;
response.write rcset(&quot;first&quot &amp; &quot; &quot;
response.write rcset(&quot;dept&quot
rcset.movenext
loop


%>