Error with string to GUID in SQL server
Posted on 2004-10-06
I have created a column in my Clients SQL table of type uniqueidentifier. The Problem I am having is this. Since I have done this I am not able to delete data directly (or otherwise) from the table. I highligh all the fields and values and select delete.. Then I get the following error:
"No rows were updated."
"The data in row was not commited."
"The source: System.data.
"Error Message: Failed parameter value from a string to Guid."
"Correct the errors and retry or press ESC to cancel the change(s)."
What did I do to deserve this? :)... - or - more importatly.. what can I do to change this.