🚀 go-pugleaf

PageSize is not property of ADO Command. It is a property (but not member of
Properties collection) of ADO Recordset. So, you need something like:
ADOQuery1->Recordset->PageSize = 64;
or
rc->Recordset->PageSize = 64;
depending on which type is rc (I suppose it is something that inherits from
TCustomADODataSet). You may also check that rc->Recordset is not NULL.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com

"Chris" <Chris.Bucher@sas.com> �������/�������� � �������� ���������:
news:3cb45a8f_2@dnews...
> I have Borland C++ Builder 6 and I am am trying to run a query against the
> active directory.
> The problem is that only 1000 records are returned.  The solution is to
set
> the Page Size property of the Command object
> to a larger number, say 64.  This works in VB.
>
> When I try it in C++ Builder, first it gave me a linker error that
> CheckAutoResult was not found.
> I worked around that problem by adding:
>
> namespace System {
>     void __fastcall CheckSafecallResult(HRESULT hr)
>     {
>         OleCheck(hr);
>     }
> }
>
> Now when I set the property the error code says that property is not
> available.
>
> Here is the code:
>
>         comm->Properties->Item["Page Size"]->Value = 64;   // This line
> gives an error saying that Page Size is not in the collection.
>         rc->Recordset = comm->Execute();
>
>         while(!rc->Eof){
>                 ... do something
>             rc->Next();
>        }
>
> If I take out the Page size setting, the code does work but only retreives
> 1000 rows (an Active Directory thing).
>
> Can someone help me?
>
> Thanks
> Chris
>
>