ActualSize returns -1

24 May 2005 12:59 PM

UGH

I am using ADO 2.8 and MS SQL. One of the fields type is set to text so I
need to use the getchunk method to retrive the value.

I know that the values are not blank and even if it was it would return zero
not -1.

rsConn.Fields("field").ActualSize.

Any one know what I am doing wrong?

24 May 2005 1:15 PM

UGH

I figured out what I did wrong.

I changed from this
rsConn.Open sql, conn, adOpenForwardOnly, adLockOptimistic, adCmdText

to this
rsConn.Open sql, conn, adOpenKeyset, adLockOptimistic, adCmdText

Show quoteHide quote

"UGH" <nospam@noSPam.com> wrote in message
news:evh3VDGYFHA.2380@tk2msftngp13.phx.gbl...
>I am using ADO 2.8 and MS SQL. One of the fields type is set to text so I
>need to use the getchunk method to retrive the value.
>
> I know that the values are not blank and even if it was it would return
> zero not -1.
>
> rsConn.Fields("field").ActualSize.
>
> Any one know what I am doing wrong?
>
>

24 May 2005 1:50 PM

Paul Clement

On Tue, 24 May 2005 08:59:35 -0400, "UGH" <nospam@noSPam.com> wrote:

¤ I am using ADO 2.8 and MS SQL. One of the fields type is set to text so I
¤ need to use the getchunk method to retrive the value.
¤
¤ I know that the values are not blank and even if it was it would return zero
¤ not -1.
¤
¤ rsConn.Fields("field").ActualSize.
¤
¤ Any one know what I am doing wrong?
¤

This value usually indicates that the property is not available. It could be because of the cursor
type or cursor location you are using. A little more code might help so we can see what those are.

Paul
~~~~
Microsoft MVP (Visual Basic)