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

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 thereis 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." I didn't have to read this to know it, but I did have to read it to prove it. :-) ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com