By default TIBO table string fields become blobfields if more than 255
character in length

IB_Session

{: This global variable sets the limit for a VarChar to be
returned as a ftString FieldType, before it becomes a ftMemo FieldType
in TIBODataSet.}
MaximumStringSize: Integer = 255;

Just assign a new value to the global vairiable

MaximumStringSize = 3072 // or 4096

----- Original Message -----
From: "Robert martin" <rob@...>
To: <IBObjects@yahoogroups.com>
Sent: Sunday, November 18, 2007 2:45 PM
Subject: [IBO] TIBOTable Weirdness


> Hi
>
> We have an application that is using TIBOTable (for legacy reasons) that
> has recently started to fail. We increased the size of a field to 3072
> characters (varChar) from about 70. Now when this field is accessed
> using Table.AsString instead of returning an empty string (when NULL) is
> returns 8222 empty spaces. Table.IsNull returns true. It is relatively
> easy to fix the code (just use an isNUll test). However it seems their
> might be some bug with the code if the functionality changes with
> increased field sizes.
>
> We are using IBO v 4.8.6
>
> --
> Rob Martin
> Software Engineer
>
> phone +64 03 377 0495
> fax +64 03 377 0496
> web www.chreos.com
>
> Wild Software Ltd
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>