Search results for query: *

I'd say you were having problems here: sum(decode(unit_base.line_id,80000376,strMonth,0)) strMonth is a char and 0 is a number. The evaluation of the decode happens before the sum, so you try to sum up 0 with a 3 char field. Of course aum only works with numerics. What I would suggest is...

In testing you could use DBMS_OUTPUT to send data/comments to the screen. Aulthough this is not always the best solution, it helps with debugging.

you need to use a subquery to do this: delete from base_tbl where unit_id in (select unit_id from base_tbl,unit_tbl where base_tbl.unit_id=unit_tbl.mem_id and substr(unit_tbl.mem_name,1,1) = 'M'); the important thing is seperating out the subquery to...

OK I figured it out and the macro was pointing to the wrong report location. Thank you again for your patience.

Thanks trev, that got me past the error. I run through the macro now, but I don't get a screen or a report. I have uncommented the printout line. Do I have to define a specific printer and if so how do I do that?

I guess the solution I am looking for, in the long run is some way to run Impromptu from a batch process. My batch process currently ends with table creation. What I would like to do is run impromptu at the end of that job. Now (of course) the batch job is on our UNIX machine and Impromptu runs...

OK, I figured out how to add and modify a macro and I believe the report I created to count the rows in a table is working. When I run the macro I get the error "test!main(9) - R429 "object creation failed - bad object class" The following line is highlited: Set ImpApp =...

Also I'm using version 5.0.401.1

I am new to Impromptu and scheduler. I have 3 reports that are "monthly", but I have no control on the exact date the data will be available for the reports. There is a process that populates oracle tables and the developer/user currently runs the reports manually. I need the scheduler...