Consistent Recordset Issue

[Lenin]

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

[NHOEL]

"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