Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
GUID fields |
Tue, Jan 8 2008 12:09 PM | Permanent 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 PM | Permanent Link |
Roy Lambert NLH Associates 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 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |