Re: ace report?

Jim Kistler wrote: > > Is there a restriction on "update"ing a temporary table in the > Select section of the ACE Report Writer? Yes; you can only use SELECT ... INTO TEMP statements. This fails if the table already exists, so each such statement must create a new table. > A "select" statement that runs fine in ISQL fails in "ace" and I > can't see the syntax problem! Are you sure it is a pure SELECT statement? > I want to do a select to a temporary table, update the temporary table > with another selected value, then do a final select for the report. The UPDATE is out; the closest approach would be to select the updated values and the non-updated values into a new temp table, possibly using UNION to combine disjoint sets of rows. > The ACE compiler seems to be focusing on the "update" phrase starting > after the first "select ....... into temp table" clause. And so it should; UPDATE statements are not part of the ACE language. > Works fine in ISQL but not ACE? ISQL is not ACE. > What am I missing? ACE only allows you to write: SELECT ... INTO TEMP x1; [...] SELECT ... {NO INTO TEMP -- optionally an ORDER BY} END See, for example, the book Using Informix-SQL by one Jonathan Leffler. Yours, Jonathan Leffler (jleffler@earthlink.net) #include <advert.h>