>>I created a form added a ADODC to it and added MSHflexgrid that uses ADODC but ADODC does not accept a Recordset result as value, it only accept Table, Text or Stored procedure.
>
>Don't set the Recordsource property, set the Recordset object.
>

Set Adodc1.Recordset = YourRecordset

Thanks Eric

Here's what cause the problem/misunderstanding
in the code there are a loop

Do Until ClassInstance.EOF
...
...
Loop

I assumed that ClassInstance(is not call ClassInstance in the code) is a RecordSet because of
teh apparant EOF and I got error everytime I assign it to ADODC.recordset BUT it turn out that EOF
is a method of the class.

my question, is this procedure a common way to get data out of a class???

I hope I am clear, a class X being called by other class Y and Class Y uses a recordset that
was built in Class X. Using Oracle 8i and VB6

Thanks
Mo