Previous Thread:   Controling tha Parse method

1/22/2006 6:43:39 AM    Re: This method or property cannot be called on Null values!
"Leila" <Leilas@hotpop.com> wrote in  
  
news:ebeDa8zHGHA.3700@TK2MSFTNGP15.phx.gbl:  
  
It's an internal Management Studio error, and I am not entirely sure  
  
what method/prop it tries to call.  
  
If you do the same from sqlcmd (or some other client), it works OK.  
  
Niels  
  
--  
  
**************************************************  
  
* Niels Berglund  
  
* http://staff.develop.com/nielsb  
  
* nielsb@no-spam.develop.com  
  
* "A First Look at SQL Server 2005 for Developers"  
  
* http://www.awprofessional.com/title/0321180593  
  
**************************************************



1/22/2006 7:19:51 AM    Re: This method or property cannot be called on Null values!
Kent Tegels <ktegels@develop.com> wrote in  
  
news:b87ad742dca28c7ed481d20c6e0@news.microsoft.com:  
  
Sure, but this is the "usual" SSMS bug. Management studio is doing some  
  
weird stuff, not SQL Server.  
  
Niels  
  
--  
  
**************************************************  
  
* Niels Berglund  
  
* http://staff.develop.com/nielsb  
  
* nielsb@no-spam.develop.com  
  
* "A First Look at SQL Server 2005 for Developers"  
  
* http://www.awprofessional.com/title/0321180593  
  
**************************************************

1/22/2006 1:59:24 PM    This method or property cannot be called on Null values!
Hi,  
  
According to my previous posts about controlling NULL value in Parse method,  
  
I have another question:  
  
When I perform a SELECT * (without using ToString() method) I get this  
  
error:  
  
"An error occurred while executing batch. Error message is: Data is Null.  
  
This method or property cannot be called on Null values"  
  
I'd like to know that which method/property cause this error. In other  
  
words, what does SELECT * call?  
  
Thanks every body who participated in solving my previous problem!  
  
Leila

1/22/2006 2:51:05 PM    Re: This method or property cannot be called on Null values!
Hello Leila,  
  
Well, let's see the full query, but normally a select doesn't call any method,  
  
it just emits the binary serialization of the object rendered as a hex string.  
  
Thank you,  
  
Kent Tegels  
  
DevelopMentor  
  
http://staff.develop.com/ktegels/