|
Posted by Liang Zhang on 10/02/84 11:45
Yeah, I also found this problem of visual studio some time.
"ZRexRider" <jerryg@ptd.net> wrote in message
news:1144717149.274781.120350@u72g2000cwu.googlegroups.com...
> 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 ......
>> >
>
Navigation:
[Reply to this message]
|