Buddy:
'Preciate your thoughts. I'll be experimenting this weekend and report
back.
Bruce
------ Original Message ------
Sent: 7/21/2016 12:46:39 PM
Subject: RE: [RBASE-L] - Converting BLOB Column to TEXT (X): Got it.
From: "Buddy Walker" <[email protected]>
To: [email protected]
Cc:
Bruce
I don’t believe you can change a BLOB column to text
You would have to add another column (YourNewTextColumn) text (100), I
would put next to YourBlobColumn
Someone else may have another way of doing this
EDIT YourBlobColumn YourNewTextColumn from tablename WHERE
YourBlobColumn IS NOT NULL
Click and open the blob exposing the text, copy text then paste it
into YourNewTextColumn
I’m not sure if this could be done through programming.
Once you are done and satisfied delete blob column and if you want you
could rename YourNewTextColumn to the oldBlobColumnName. Then you may
have to check all forms, reports and labels to make sure the datatype
changed to match YourNewTextColumn
Buddy
From:[email protected] [mailto:[email protected]] On
Behalf Of Bruce Chitiea
Sent: Thursday, July 21, 2016 2:56 PM
To:[email protected]
Subject: Re: [RBASE-L] - Converting BLOB Column to TEXT (X): Got it.
------ Original Message ------
Sent: 7/21/2016 8:00:31 AM
Subject: [RBASE-L] - Converting BLOB Column to TEXT (X)
From: "Bruce Chitiea" <[email protected]>
To: "[email protected]" <[email protected]>
Cc:
All:
Created and populated a BLOB column. Didn't need to be BLOB, should be
TEXT (X).
Suggestions on fastest, bestest way to preserve/convert data, while
redefining table column?
Thank you,
Bruce Chitiea
SafeSectors, Inc.
909.238.9012 Mobile
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
For more options, visit https://groups.google.com/d/optout.
--
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
