Upgrade to Informix 3.81 ODBC driver
Posted in 2003
The
following statement worked under Merant 3.60 driver but doesn't work
using IBM Informix 3.81 driver.
INSERT INTO lmn_opt_desc(id, short_desc, long_desc, voucher_comment)
VALUES(68, 'test', 'test', '')
The merant driver was obviously doing something clever to be able to insert
into a 'text' field.....anyone know of a workaround ?
create table "informix".lmn_opt_desc
(
id integer not null ,
short_desc varchar(255) not null ,
long_desc text not null ,
voucher_comment text,
primary key (id)
);
------------------------------
This e-mail is intended for the named addressee only. It may contain
confidential and/or privileged information. If you have received this message
in error, please let us know and then delete this message from your system.
You should not copy the message, use it for any purpose or disclose its
contents to anyone.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________