Re: TEXT datatype usage from Powerbuilder DataWindow

Tim Thornburn 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