Strange sqlcode...
Hi.
I'm getting a strange error on an insert into a table:
-31551
I can't find this documented anywhere!
The table is defined as:
CREATE TABLE t_logon_log
(assoc_id integer NOT NULL,
login_date date NOT NULL,
login_time integer NOT NULL,
appl_num integer,
logout_date date,
logout_time integer,
login_nodename char(32),
PRIMARY KEY (assoc_id, login_date, login_time)
)
in structdbs
extent size 64
next size 64
lock mode row;
and the insert statement is:
INSERT INTO t_logon_log
VALUES (1, TODAY, 40234, 2, NULL, NULL, "clawton")
The code is from *Plexus's* Windows 4gl 4.0 (People at Informix should be
familiar with Plexus) and Online 5.
I'm really stumped as the insert statement works fine from isql but not from
the program! Any help would be greatly appreciated!
Please email responces.
Thanks,
Chris Lawton
clawton@tfs.com