Mr. Frankie Loh Teck Seng:

I am thinking that you may have set your Record Source incorrectly in your
ADO properties.
For Table bindings and FlexGrids, you may need to use 2-adcmdTable in your
RecordSource Command Type.

Ofcourse, I cannot be certain here, but this looks very much like the
problem.

Richard

----- Original Message -----
From: Frankie Loh Teck Seng <lohts@p...>
To: professional vb <pro_vb@p...>
Sent: Monday, May 15, 2000 4:54 AM
Subject: [pro_vb] Re: COM/DCOM in N-Tier Architecture Environment


> Warmest greeting to all;
>
> Recently I tried to a N-Tier Architecture system using COM/DCOM
> features together with Microsoft Transaction Server. I build one
> method solely responsible in retrieving the recordset based on user
> supplied SQL statement. At end, these method supposed to return
> recordset back to the caller.
>
>    At the client site, I can received the recordset, loop through them
> and do the necessary things I wanted. However, I am not able to bind
> the recordset to control box like Hierarchical FlexGrid or list box
> (without using combo box). I desperately need anyone advise or comment
> on the methodology or approach to bind the recordset to the control box.
>
>     Thanks very much and hope can here from you.
>
>     Bye.
>