Re: TEXT datatype usage from Powerbuilder DataWindow

"Chao Y. Din" <cdin@csc.com> wrote: >> Hi! >> >> I posted a simular question earlier but I was not specific enough... >> >> I am converting a Watcom Long Varchar (unlimited size) to Informix. >> The application is written in Powerbuilder. >> >> Currently, with Watcom, the Long Varchar fields are just datawindow >> columns and the DW knows how to update them. Simple. >> >> I ported these fields to Informix TEXT fields. The DW does not >> generate valid SQL, it tries to update the field in the same UPDATE >> clause. Arrrgh. >> >> I am using Informix 5.1. Do any of the later versions of Informix >> allow the standard Update statement to update a TEXT field? >> >> It will be major surgery to modify all my programs to use embedded SQL >> for the TEXT fields. Any suggestions will be GREATLY appreciated!!! >> > >I am still not sure why you want to use TEXT instead of varchar data >type. Anyway, you can use Powerbuilder's UPDATEBLOB to update Informix >TEXT. > >Chao BTW, My computer was down for repair so I used another in my company... (Hence the name Tim) A Varchar is limited to 255 bytes. A TEXT field is of unlimited size. My client writes copy material for book catalogs. Some of it can be very long, they are researching to see if they can live within the 32,767 character limit imposed by the Char. But. It I have to use a Char the DB is going to grow significantly. To switch from a DW doing all my updating to using the UpdateBLOB will require redesigning much of the application. Roger Meyers roger@stratsoft.com Strategic Software Solutions, San Francisco, CA