Adding Blob sub_type 1 fields

[Terry Black]

Hi, I have created a new Firebird table with several fields including a Blob sub_type 1 field. Everything is working OK. When I add a new Blob sub_type 1 field called 'Comments' to my table it defaults to Blob sub_type 0.

 

Can anyone suggest how can I add a new Blob sub_type 1 field to my  existing table.

 

 

Terry

Disclaimer: Unless explicitly attributed, the opinions expressed in this email are those of the author only and do not represent the official view of Northern Sydney Central Coast Health nor the New South Wales Government.

------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel

[Milan Babuskov-4]

On Fri, Jun 10, 2011 at 5:31 AM, Terry Black
<[hidden email]> wrote:
> Hi, I have created a new Firebird table with several fields including a Blob
> sub_type 1 field. Everything is working OK. When I add a new Blob sub_type 1
> field called 'Comments' to my table it defaults to Blob sub_type 0.
>
> Can anyone suggest how can I add a new Blob sub_type 1 field to my  existing
> table.

This is currently not available via field dialog, but you can always
run the SQL manually:

alter table T1 add B1 blob sub_type 1;

--
Milan Babuskov
http://www.guacosoft.com

------------------------------------------------------------------------------
EditLive Enterprise is the world's most technically advanced content
authoring tool. Experience the power of Track Changes, Inline Image
Editing and ensure content is compliant with Accessibility Checking.
http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________
Flamerobin-devel mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/flamerobin-devel