proberts@disk.uucp (Phil Roberts) (06/01/91)
Is it possible to include an update statement within an Informix/SQL
ACE Report?
I want to update a column after each row prints. Can this be done?
I know that I can run the ACE Report and then execute a SQL script, but
I would rather do it as the ACE Report executes.
Thanks for any replies that are provided. Post or e-mail.
--
_______________________________________
Phil Roberts | Internet: proberts@disk.uucp
Louisville, Kentucky | UUCP: uunet!coplex!disk!proberts
| MILNET: proberts@ky-ngnet.army.mildas@trac2000.ueci.com (David Snyder) (06/02/91)
In article <1991Jun01.031216.20851@disk.uucp>, proberts@disk.uucp (Phil Roberts) writes: > Is it possible to include an update statement within an Informix/SQL > ACE Report? > No, unless you create a new sacego with Informix-ESQL/C. Personally, I'd just write the report with Informix-4GL. DAS -- David A. Snyder @ UE&C - Catalytic in Philadelphia, PA UUCP: ..!uunet!trac2000!das INTERNET: das@trac2000.ueci.com
lugnut@sequent.UUCP (Don Bolton) (06/04/91)
In article <1991Jun01.031216.20851@disk.uucp> proberts@disk.uucp (Phil Roberts) writes: >Is it possible to include an update statement within an Informix/SQL >ACE Report? > >I want to update a column after each row prints. Can this be done? >I know that I can run the ACE Report and then execute a SQL script, but >I would rather do it as the ACE Report executes. > >Thanks for any replies that are provided. Post or e-mail. > Nyet, nein, no way jose. No problem in 4gl but not a feature of ace Don "one of my first wishes too" Bolton
lance@mpd.tandem.com (Lance Hartmann) (06/07/91)
You can "sort of" issue an update statement from an ACE report if you have ESQL/C. That is, you can make a 'c' function call from the report to do so... -- Lance G. Hartmann - cs.utexas.edu!devnull!lance (Internet) ------------------------------------------------------------------------------- DISCLAIMER: All opinions/actions expressed herein reflect those of my VERY OWN and shall NOT bear any reflection upon Tandem or anyone else for that matter.