Very Computer

I'm accessing to Informix 7.31 through ADO (OLE DB for ODBC drivers) and
Delphi 6. ADO seems to be puzzled by Informix stored procedures
returning columns without name.
I can access to data in a dataset by using COLUMN1, COLUMN2... as column
names but when I try to use them to sort or filter it, it fails with the
following message:

'Item cannot be found in the collection corresponding to the requested
name or ordinal'.

I tried different things, like using brackets, but no way...
Any idea?

Thanks in advance,

Pascal

HTH

Paul McLaughlin

Quote:> Hi,

> I'm accessing to Informix 7.31 through ADO (OLE DB for ODBC drivers) and
> Delphi 6. ADO seems to be puzzled by Informix stored procedures
> returning columns without name.
> I can access to data in a dataset by using COLUMN1, COLUMN2... as column
> names but when I try to use them to sort or filter it, it fails with the
> following message:

> 'Item cannot be found in the collection corresponding to the requested
> name or ordinal'.

> I tried different things, like using brackets, but no way...
> Any idea?

> Thanks in advance,

> Pascal

thank you for your help.
The only workaround I've found so far is to insert rows into a temporary
table and not to drop it when the procedure returns and finally to base
my query on the table. I don't like this solution too much but I'm
afraid I've got no choice since I don't think I can write a sort or
filter clause without naming the fields.

Pascal