Consistent Recordset Issue


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Consistent Recordset Issue

  1. #1
    Lenin Guest

    Consistent Recordset Issue


    Hi,
    doea anyone know if there is an issue with returning the recordcount from
    a recordset retrieved from a parameterised command object? I recieve a recordcount
    of -1 which under normal circumstances would point to a cursor type issue.
    However I have tried all the available cursortype, and haveactually executed
    the command in different ways.

    i.e.
    set recordset_name = new ADODB.Recordset
    lrs_recordset_name.cursortype = adOpenstatic 'OpenDynamic etc
    set recordset_name = command.execute

    Also in case the attributes of the recordset are over written by the records
    returned form the comman, I tried:

    lrs_recordsetname.open command.execute

    I have tried all the usual avenues of investigation.

    Any relevant input would be much appreciated.

    Thanks

  2. #2
    NHOEL Guest

    Re: Consistent Recordset Issue


    "Lenin" <tony.hamill@unibol.com> wrote:
    >
    >Hi,
    > doea anyone know if there is an issue with returning the recordcount from
    >a recordset retrieved from a parameterised command object? I recieve a recordcount
    >of -1 which under normal circumstances would point to a cursor type issue.
    >However I have tried all the available cursortype, and haveactually executed
    >the command in different ways.
    >
    >i.e.
    > set recordset_name = new ADODB.Recordset
    > lrs_recordset_name.cursortype = adOpenstatic 'OpenDynamic etc
    > set recordset_name = command.execute
    >
    >Also in case the attributes of the recordset are over written by the records
    >returned form the comman, I tried:
    >
    > lrs_recordsetname.open command.execute
    >
    >I have tried all the usual avenues of investigation.
    >
    >Any relevant input would be much appreciated.
    >
    >Thanks


    try using this before opening the recordset: lrs_recordsetname.CursorLocation
    = adClientSide

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center