Re: Informix SE on Solaris, using ACE report writer...

--- "Obnoxio The Clown" <obnoxio@hotmail.com> > wrote: >From: Carlos Benjamin <benj@firstlinux.net> >> >>--- mars1972@my-deja.com >> > wrote: >> >Unless I'm missing something, you can only have one SQL statement in an >> >ACE report. What you might want to do is create a stored procedure that >> >figures out all the records you want and call the stored procedure in >> >the SQL section of the ACE report. >> > >> >>I believe you can do multiple SQL's in an ACE report. You could, for >>instance, in the ON EVERY ROW portion of the report select some info from a >>table based on one of the already selected rows (to get a description >>perhaps). > >From the ISQL reference manual, page 4-37: > >"The SELECT section begins with the SELECT keyword. This keyword introduces >both the SELECT section and the first SELECT statement. Other SELECT >statements can follow the first'each must begin with the SELECT keyword. All >SELECT statements, except for the last, must end with a semicolon. (If there>is only one SELECT statement, it does not require a semicolon.) The SELECT >section ends with the END keyword. All but the last SELECT statement must >have an INTO TEMP clause." Thank you for that SELECT passage. >I didn't have to read this to know it, but I did have to read it to prove >it. :-) To prove you could read? == Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be. _____________________________________________________________ Want a new web-based email account ? ---> http://www.firstlinux.net