Getting the results columns before execution

Hi all,

From the OLE DB manual:

> The consumer can also get information about the columns of the rowset
> by calling IColumnsInfo::GetColumnInfo, which all providers must
> support, or IColumnsRowset::GetColumnsRowset, which providers may
> support, on the command.
>
> Before calling GetColumnInfo or GetColumnsRowset, the consumer must
> set the command text and, if the provider supports command
> preparation, prepare the command object.
>
The problem - it appears there is no requirement to execute the command
before asking about the rowset returned. Only setting the actual command
and preparing it. This is a problem, as merely preparing a command is
not enough to get the returned rows information.

I'm wondering whether anyone on this list(s) have an idea how to solve
this? I can start the command in a cursor, and not retrieve information
until requested. I can also execute the command with "where 0" appended
to it. Neither solutions seem very practical or good performance wise.

Shachar

--
Shachar Shemesh
Lingnu Open Systems Consulting
http://www.lingnu.com/