Problem with ISQL aces
Hi there.
I have a problem with long reports that used to run fine with
ISQL 2.10.03K
Ultrix 4.1
DECsystem 5500
but under
ISQL 4.10.UE2 and I-OnLine 5.00.UC4
AIX 3.2
RS/6000 570
the very same reports compile but don't run.
One such example is:
/--------------------------------------------------
database scg end { database }
select ctonum from contra end { select }format
on last row
print column 26, "AAA", column 34, "B", column 48, "CCCCC", column 64, "D",
column 72, "EEEEEEEEE", column 84, "FFFFFFFFF",
column 96, "GGGGGGGGGGGGG", column 111, "HHHHHHHHHHHH",
column 125, "IIIIIIIIIIII", column 139, "JJJJJJJJJJJJJ",
column 152, "VAL.1. RENDA"
.
.
.
{ 57 print statements just like the first one }
.
.
.
end { format }
--------------------------------------------------/
The report has a total of 295 lines and no blank lines.
If I erase one line from the report everything works fine!
Running the report gives the following result:
/--------------------------------------------------
The reading of the database will now begin.
Select statement number 1 will now be processed.
The reading of the database has finished.
The column "" is not in the current table, or
the user variable "" has not been defined.
Source code line number 0.
See error number -9004.
--------------------------------------------------/
Finderr 9004 gives:
-9004 The column name is not in the current table,
or the user variable name has not been defined.
The name shown cannot be related to either a column in a
database table or a defined variable. Check its spelling.
If you meant it to be a variable, add it in the DEFINE
section. If you meant to name a column in the database, check
to see if the table has been altered or its columns have been renamed.
Can anybody give me a hand?
Thanks a lot,
Joao Nuno Cardoso
jnc@ssf.pt