🚀 go-pugleaf

Ok, I solved the problem.  Borland does not set the connection to the
command until Execute is called.  So you need to do it yourself in order to
set the Page Size property.  See below:

// Need to set in order to set Page size
cmd->CommandObject->Set_ActiveConnection(conn->ConnectionObject);

// Need to set page size in order to retrieve more than 1000 records
cmd->Properties->Item[WideString("Page size")]->Value = 64;       // Note:
Must use cast to WideString

rc->Recordset = cmd->Execute();


Thanks to Vassiliev V.V. for your assistance.



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