Re: Help with read in 3.3 ace report

Douglas, I found my old manuals(Informix 3.0 1983) and maybe I can help. Does one of your reads select data from the same file as the field you would like to add? You should be able to add the field to that read statement as Graeme suggested. The base syntax is: read [into temp_table] fieldlist { where clause } { join clause } end There may be many read statements into temp tables, but the last read statement is what is passed on to the format section so your field needs to show up there. Email some sample code and I can at least look up how it should work. Its been a long time since I have used it. Regards - Lester ############################################################################# # Lester Knutsen lester@access.digex.net # # Advanced DataTools Corporation Voice: 703-256-0267 # # Grant group privileges for Informix databases with DB Privileges # ############################################################################# > Douglas R. Probst (doug@catseye.snide.com) wrote: > : I am working on an old Altos system with a mid 80's version of 3.3 > : I have to alter a report and to do so I need to read a field as they call > : then, that is not selected in the existing reads. Can I add > : read fieldname > : where idnu = param > : then later in the FORMAT section say > : if (fieldname = "A" or fieldneme = "B") > : then > : let total_cost = 25 > : else > : let total_cost = 50 > : There are 2 other existing reads, but both read into something. > : do I have to read into something? > : The fieldname is in the selected database for the report and all I need is > : the value in that field where the passed = the file_no for that record. > : BTW if this was posted twice I am sorry but I had some news trouble, please > : forgive me.