Help UniqueIdentifier

[Rafael tejera]

I have a table with many uniqueidentifiers fields, sometimes some fields are
empty, but I cannot sent an empty string to a uniqueidentifier, How I can
sent null values whenever is necesary without having to rewrite my sql
statement. I have sent values like "" and "null" and it does not work.

what I can do?


Rafael

 

[Guest]

I am not sure this even makes sense. Usually, if you have a UNIQUEIDENTIFIER
column, you don't want it to accept nulls. You would want it to autogenerate
with RowGuid setting. Why do you want to send null values? Maybe you should
be using a Varchar column?
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
BlogMetaFinder(BETA): http://www.blogmetafinder.com

 

[Rafael tejera]

They are combobox fields. So, they point to another database, and the
standard that I must use is uniqueidentifier.


Rafael

 

[Pramod Anchuparayil]

Look at DBNull.Value

They are combobox fields. So, they point to another database, and the
standard that I must use is uniqueidentifier.


Rafael