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] <mailto:[email protected]> > To: "[email protected] <mailto:[email protected]> " <[email protected] <mailto:[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] <mailto:[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] <mailto:[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.
