NULL values when printing report
Posted in 2000
When i print a report from table sdtsui (described below), null values
are inserted (after the desc_suivi field) and some lines are too long.
In the output section, i put report to "test.out". When i open this file
with vi, it tells me that there are 2 nulls. When i open it with
textedit, i can see the strange ^@ character 2 times. It seems that ^@
is converted with many spaces when being print. Any hints ? Thanx.
here is the structure of the table:
create table sdtsui
(
no_demande integer not null ,
date_suivi date not null ,
no_suivi serial not null ,
desc_suivi char(260), { informix SQL 7.24 is buggy with char fieldsover 250-300 char ... }
date_cree date,
date_maj date
);
--
Daniel Racine
Analyste-programmeur
Ville de Sherbrooke