Posted by ZRexRider on 04/11/06 03:59

The parameters are fine. As I said earlier - everthing in my code and
stored procedures are working perfectly.

The problem was, for some odd reason when you use Visual Studio to view
the table it shows a blank field but if you look at the exact same
field using SQL Server Enterprise you see that the data really is
there.


So the "issue" turns out to be - Microsoft Visual Studio 2003 will not
display the contents of a varchar field that has more than 900 bytes.
And in my case, I tried to fix everything else!!


DickChristoph wrote:
> Hi
>
> Have you checked the length of the parameter defined in the .Net
> application?
>
> --
> -Dick Christoph
> "ZRexRider" <jerryg@ptd.net> wrote in message
> news:1144419858.910381.155540@g10g2000cwb.googlegroups.com...
> > Thanks Denis - you had my hopes up but nope - this field is not an
> > index.
> >
> > I am able to cut and paste any size into this field through SQL
> > Enterprise Manager . It's just when I try to pass a chunk of data over
> > 900 bytes through a strored procedure parameter.
> >
> > I hate to build a direct SQL Update into my application but ......
> >

[Back to original message]