All these tests where done on an 
 - NT4.0 System latest Service Packs
 - MSSQL Server 6.5 (Running on the same machine).
 - PHP 3.06 Win32 Binary supplied from the PHP website.


This is what odbc_fetch_row currently does.
-------------------------
$status = odbc_fetch_into($q->Query_ID,0,&$testarray);

1. Reads the current row into the array $testarray .
2. Increments the row so that the next call to row 0 is the next record.

This works perfectly.
-------------------------
and
-------------------------
$status = odbc_fetch_into($q->Query_ID,4,&$testarray);

1. Fails due to the fact that specific rows are not available in MSSQL.

This should ignore the rownumber as it is not supported by MSSQL.
--------------------------

Also odbc_fetch_row( ) behaves as follows.
--------------------------
$status = odbc_fetch_row($q->Query_ID);

1. Fetches the current row and moves the cursor/row position forward 1.

Works Perfectly.
--------------------------
$status = odbc_fetch_row($q->Query_ID,5);

1. Fetches the current row.

This does not advance the cursor/row position forward 1.
This may not be a bug but it can cause serious problems with the PHPLib.
If possible can the rownumber be ignored if it not supported and the cursor advanced 1.
---------------------------

In short odbc_fetch_into( ) needs to ignore the rownumber when not supported by the database.
odbc_fetch_row( ) needs to autoincrement the cursor when rownumber is supplied to the function but not supported by the database.

or

Find a way to have the rownumber working with ODBC and MSSQL 6.5
(I would try if I had the slightest idea where to start and knew how to compile a Win32 binary. :) )


The Code
-------------------------------
$testarray = array();

$status = odbc_fetch_into($q->Query_ID,0,&$testarray);
echo "Stat is -- ".IntVal($status).".";
echo "Here it is -- ".$testarray[1]."<BR>";

$status = odbc_fetch_into($q->Query_ID,4,&$testarray);
echo "Stat is -- ".IntVal($status).".";
echo "Here it is -- ".$testarray[1]."<BR>";

$status = odbc_fetch_into($q->Query_ID,0,&$testarray);
echo "Stat is -- ".IntVal($status).".";
echo "Here it is -- ".$testarray[1]."<BR>";

$status = odbc_fetch_row($q->Query_ID,1);
$value = odbc_result($q->Query_ID,2);
echo "Stat is -- ".IntVal($status).".";
echo "Here it is -- ".$value."<BR>";

$status = odbc_fetch_row($q->Query_ID,3);
$value2 = odbc_result($q->Query_ID,2);
echo "Stat is -- ".IntVal($status).".";
echo "Here it is -- ".$value2."<BR>";

-----------------------------
Returns the results
-----------------------------
Stat is -- 19.Here it is -- Bail
Stat is -- 0.Here it is -- Bail
Stat is -- 19.Here it is -- Cash
Stat is -- 0.Here it is -- Cash
Stat is -- 0.Here it is -- Cash