Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread GUID fields
Tue, Jan 8 2008 12:09 PMPermanent Link

Allan Brocklehurst
hello;
stats D&, DBIDAM v4.25b7
I have a GUID field that I had to change to a string field type , frankly because Iscrewed up. I then updated this field, OID, with new strign values. I would really like to set the field type
back to GUID still retaining the String Values.  I tried but it failed and inserted new GUID values

DO I have a hope in hell of doing this?

TIA

Allan
Tue, Jan 8 2008 1:13 PMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Allan


Probably. I think I'm right is saying that in DBISAM a GUID field is a special case of string field so what you need to do is:

1. Add a new column with GUID type
2. UPDATE that field with the data from the now string column
3. delete the string column
4. rename the guid column

You can do the lot with a single SQL script, or do it step by step in DBSys if you prefer.

Roy Lambert
Tue, Jan 8 2008 9:44 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Allan,

<< stats D&, DBIDAM v4.25b7
I have a GUID field that I had to change to a string field type , frankly
because Iscrewed up. I then updated this field, OID, with new strign values.
I would really like to set the field type back to GUID still retaining the
String Values.  I tried but it failed and inserted new GUID values >>

Do you have a default expression defined for the field ?  If not, then I
can't see how the field was populated with new GUID values.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image