ADO Database Query with Store

[DannyC]

Hi

Can any body help me with the following scenario.

In VB,I am populating a Recordset by running a Stored Procedure in sybase thru an ADO DB query

however, the Stored procedure produces its results in two selects. for example, the results are:

Field1 Field2 Field3
a b c
Field1 Field2 Field3 Field4 Field5
1 2 3 4 5

Notes:
* I Can't Use UNION on the SQL proc, due to the different no of Fields returned, and their different defs (Char/int)
* Cant do two DB Queries, as the results are in #TMP tables and only exist when we run the SQL proc

Is there a way to read the recordset
a b c (firstrecord)
1 2 3 4 5 (secondrecord)

Any ideas
Thanks for reading
Danny

 

[MarkSweetland]

Couldn't you convert all fields to varchar, dummy up the extra fields in the first select with nulls to do the UNION, and then convert numeric fields back once its returned?

Mark