🚀 go-pugleaf

More info:

I have found a work around, although a little clumsy:

    TADOCommand *cmd = new TADOCommand(NULL);
    cmd->Connection = conn;
    cmd->CommandText = "select cn from
'GC://na.nnn.com/CN=Users,DC=na,DC=nnn,DC=com' where cn='None'";
    cmd->Execute();  // I have run one dummy query in order to be able to
set the Page size below

    // Now I can set my Page size
    cmd->Properties->Item[WideString("Page size")]->Value = 64;
    cmd->CommandText = "select cn, mail from
'LDAP://na.nnn.com/CN=Users,DC=na,DC=nnn,DC=com' where objectClass =
'user'";
    adods->Recordset = cmd->Execute();  // THE REAL QUERY which will result
in almost 8000 rows
    ShowMessage(adods->RecordCount);



"Chris" <Chris.Bucher@sas.com> wrote in message 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
>
>