🚀 go-pugleaf

Ok, I've got it solved - Borland does not set the connection to the command
object until Execute is called so to set a page size property you need to
set the connection yourself.  See code snippet:

// 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 you
need the cast to WideString

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



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