>>>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

How ClassInstance is declared?