Re: ace report?

Jim, You can't run UPDATEs in an ACE report. What I would do is to change the program so it creates the UPDATE statement as its output and then PIPE the report to "dbaccess dbname". HTH. On 17 Apr 98 at 17:16, Jim Kistler wrote: > Is there a restriction on "update"ing a temporary table in the > Select section of the ACE Report Writer? > > A "select" statement that runs fine in ISQL fails in "ace" and I > can't see the syntax problem! > > 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 ACE compiler seems to be focusing on the "update" phrase starting > after the first "select ....... into temp table" clause. > > Works fine in ISQL but not ACE? > > What am I missing? > > Thanks, > > Jim > -- > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > Jim Kistler - kistler@an.hp.com # Some see issues and ask, "Why? > Hewlett-Packard Co. Imaging Systems # Others see opportunities and > 3000 Minuteman Road, Andover, MA 01810 # ask, "Why not?" > TEL: 978-659-2251 - FAX: 978-687-7265 # > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=#=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > > -- Ciao, Billy /Group Managing Director, The West Solutions Group: http://www.west.co.za \\ Drivel @ http://www.west.co.za/tasteless/ / \\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I / think we should go along with him..." \\________________________________________________________________________________________________