|
Yes, SQL - and others too - turn GUID into string...
If you read the RFC[^] you will understand why, but after all GUID is a 128 bit number...
Skipper: We'll fix it.
Alex: Fix it? How you gonna fix this?
Skipper: Grit, spit and a whole lotta duct tape.
|
|
|
|
|
Kornfeld Eliyahu Peter wrote: but after all GUID is a 128 bit number
Agree 100%.
Was just speaking about hyphens in this case with Guid identities in SQL.
|
|
|
|
|
Read the guidlines: "Insults, slap-downs and sarcasm aren't welcome. Let's work to help developers, not make them feel stupid.. "
Bruno
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Yeah, yeah, I know them.
I'm allowed to lose my cool every now and then.
|
|
|
|
|
Before you can lose something, you must have it first.
Bruno
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Developers have to first help others to help them.
This guy just isn't doing that and, much as profanity is (usually) unwelcome here, he deserved his put-down IMO.
|
|
|
|
|
"When I was 5 years old, my mother always told me that happiness was the key to life. When I went to school, they asked me what I wanted to be when I grew up. I wrote down 'happy'. They told me I didn't understand the assignment, and I told them they didn't understand life." - John Lennon
|
|
|
|
|
modified 19-Jan-21 21:04pm.
|
|
|
|
|
Are you talking about a Guid here? Do you want to remove the hyphen from a Guid? You can convert the Guid to a string and replace the - with "" to remove the hyphen.
|
|
|
|
|
|
Sweet. That's what I learned today.
Regards,
Rob Philpott.
|
|
|
|
|
So?
public string ToString("N")
|
|
|
|
|
|
|
|
how add i you to friendlylist?
|
|
|
|
|
I'm not sure what a friend list is in CP terms. If you post a question and I can help, I'll generally try to do so, so there's no need to have a friend list there.
|
|
|
|
|
okay thank you
|
|
|
|
|
+5 for the tip! This will be useful!
"Go forth into the source" - Neal Morse
|
|
|
|
|
Yes
|
|
|
|
|
I have have a textbox with id that is connected (local database relation) to gridview and that save hyphen als this -1. I have not a string?
|
|
|
|
|
What is the datatype of the identity-field? Is it a BIGINT ?
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|
Database is .sdf
Datatype is INT with Primary Key
|
|
|
|
|
Both pieces of information should have been valuable in the original question.
You don't assign a value to an identity-field. It should generate a value by itself. And a GUID will never fit into an INT. Removing the hyphen will not help.
Bastard Programmer from Hell
If you can't read my code, try converting it here[^]
|
|
|
|
|