Re: Help with read in 3.3 ace report

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 Gee, this is stretching the old memory cells. My wife bullied me into trashing my pre-SQL manuals. : 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. Forgive me if my memory fails, but I'm posting anyway on the assumption that there may not be much other 1985 vintage expertise currently monitoring this group (and if there is, they probably don't have manuals to remind them either). I expect Scott is out there, so he should correct me if I'm wrong. As I recall: A read statement is basically similar to a select statement in structure, therefore you should add the field into the appropriate pre-existing read statement, rather than creating a new statement. The into clause specifies a temporary file to store intermediate results, thus there should be an into clause on all but the last read statement. I may be wrong, but I don't think WHERE was a valid keyword in INFORMER/ACE. There was some other word which achieved the same thing wasn't there? I didn't realise how much I had forgotten, until I saw this post! -- graeme -- Disclaimer: The author's opinions are his own, and not necessarily those of Pyramid Technology Ltd. or Pyramid Technology Inc. --------------------------------------------------------------------------- -m------- Graeme Sargent Voice: +44 (0)252 373035 ---mmm----- Senior Database Consultant Fax : +44 (0)252 373135 -----mmmmm--- Pyramid Technology Ltd. Telex: Tell who??? -------mmmmmmm- Farnborough, Hants GU14 7PL Email: graeme@pyra.co.uk --------------------------------------------------------------------------- We have the technology. The tricky bit is learning how to use it.