home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases.ingres
- Path: sparky!uunet!munnari.oz.au!manuel.anu.edu.au!csc.canberra.edu.au!news
- From: mmr@asgserver.canberra.edu.au (Micheal Rainford-Watson)
- Subject: Passing a WHERE clause to Report Writer
- Message-ID: <1992Nov20.021456.903@csc.canberra.edu.au>
- Keywords: Report Writer
- Sender: news@csc.canberra.edu.au
- Organization: University of Canberra
- Date: Fri, 20 Nov 92 02:14:56 GMT
- Lines: 40
-
- I'm trying to pass a where clause to report writer to establish a
- sort of flexible labels program. The problem is when report tries to
- use the where clause it gets confused. ie:
- 4GL:
-
- za_conditions = 'employee_code='+''''+'600307'+''''+' and status='+''''+'e'+'''';
- CALL REPORT( sourcefile = '/home/user/asg/mmr/projects/labels/labels.rw',
- flags = '-h -s',
- param = 'conditions ="' +:za_conditions
- +'" address_type="C" confidential="Y"');
-
-
- Report Writer:
-
- .QUERY
- select name,
- pr_location = j.pr_cjob_name,
- address_line1,
- address_line2,
- address_line3,
- post_code
- from ahvemplabels e, prtcostj j
- where $conditions
-
- The parameter conditions is passed as employee_code='600307' and status='e' but
- the Report program thinks that 'e' is a column. This is the error
-
- E_US0836 line 1, Column 'e' not found in any specified table.
-
- Maybe I'm expecting too much?
-
- Platform is Ingres SunOS Version 6.3/01 (su4.u42/01)
-
- Any suggestions?
-
- --
- Micheal Rainford-Watson _--_|\ E-Mail: mmr@asgserver.canberra.edu.au
- Administrative Systems Group / \ Phone : +61 6 201 2397
- University of Canberra \_.--.*/ Mail : PO Box 1 BELCONNEN ACT 2616
- ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^v^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
-