ODBC connection to MS SQL 2000 help needed

[Mark Wieder]

Jan-

Sunday, April 2, 2006, 12:29:58 AM, you wrote:

> The way I solve it right now, is to query the database
> with:
>   SELECT * FROM <TheTableName>
> and append TOP or LIMIT clauses for databases that
> support this.
> Then I can use revdb_columnnames to fetch the
> information and then call revdb_closecursor without
> having read any of the data.
> But this is a waste of resources on less-efficient
> databases, as they would prep the entire data set.

Yes, that's the way I do it as well. And yes, it would be nice to have
a better way.

-- 
-Mark Wieder
 mwieder at ahsoftware.net