>Nick,
> Couple of questions -- is this coming from a text entry field ?
>
> Did you set the max length on the text entry to 40 chars ?
>
> My guess is that the char(40) field or another char is being overrun.
>
>
>Rodman
Yes this is comming from a text entry field. I didn't set max length on entry field. It seems like SQL Server is very picky about that size of parameter being sent. I noticed that my procedure and table field char length is set to 40, however the value being sent is 45 characters long. I don't know why it changed to 45 char instead of 40. I finally just did following:
IF TYPE("lxValue") = "C"
lxValue = ALLTRIM(lxValue)
ENDIF
.VALUE = lxValue
ENDWITH
and this trimming seems to work. However I still don't understand how the values are overrun? By the way is there a place where I can findout more decriptive information about error that occur with using ADO connections in vfp? Thanks for pointing me right direction.
thanks
Nick