Recent content by tradle

Paul - Best of luck! Without seeing your code, and based on your first posting, I thought that your main application was managing the process. Based on your response, absolutely, the way that you're approaching it is probably the best solution. Tim

Dave - I have little or no say over the table structure. Nevertheless, here you go... STAGE: Name Null? Type ----------------------------------------- -------- ------------- SECONDARY_NODE NOT NULL NUMBER(14) P_ID...

Paul, From what I've seen, your application needs but a single reference of this statement, similar to a variable declaration or global directive; you shouldn't in other words put it in a bunch of different places within your applicaltion allowing for the possibility of multiple calls. It is a...

Hi All - I've looked at using PL/SQL collections as suggested by HTH, and I'm afraid I don't see how they would help. Given the requirements that I have for this code, I'm still looking for a good solution. Any suggestions will be much appreciated. Regards, Tim

Thanks for your respective replies, guys. In English, this is what we're doing: data from a staging table (populated from user input) and a history table (populated by other monthly processes) is ultimately being averaged and then populated into a forecast table for accounting purposes. The...

Hi Everyone. Let me start off by saying that this is my first attempt at dynamic sql. I've been programming with PL/SQL for about a year and a half, but this is the first d-sql I've done. At issue is this: I need to populate a column based on what month it is with information that is...

Traingamer - Thanks so much for triggering my brain on this. I recreated my template such that the NAV bar was editable. I then edited each page, as you suggested, and made sure that the down state was correctly reflected on each page. It now makes sense that the states respond correctly to...

Traingamer - I completely see what you're saying about having a different state on the "current" page, and think I'll need to amend my template in order to accomodate the behavior. To answer another of your questions, I used all of the code generated from Fireworks on the template only. I...

All - Apologies if I'm missing fundamentally simple here, but I cannot get a NAV bar to behave as I expect it to. I created a NAV bar in Fireworks MX, and in that environment, everything works great; when a button is clicked, it retains the down state image until a different button is...

Aquias - After I wrote that posting, I got bold and booted into safe mode. What I found not only troubled me, it angered the heck out of me. I HAD an installation of Oracle 9i Personal (essentially the full install of the Oracle 9i database and all associated tools), and found that the...

Hi All - I have a WinXP laptop that has a 28 GB hard drive. I use maybe 3 GB with what I have on the PC. Of late, I've been getting the "out of space" message, and the computer has basically gone further and further down in terms of performance. I have Norton Systemworks 2004 on the PC, and...

All - I'm trying to update a string column with the following: UPDATE table SET column = ((Data = 'This')) WHERE condition = That; I know that I have to place something on the outside of the ((Data = 'This')) in order to have Oracle read it properly. I'm updating a string column, and every...

Hi All - I have a report that is ordered as follows: Multiple Page Header Lines Group Header with subreport Details with subreport Group Footer 1a with subreport Group Footer 1B with subreport Page Footer I'm trying to make it such that the Group Footer sections are suppressed when the...

lbass - THANK YOU!!!!!!!!!!!!!!!!!!! Tim

Madawc, Thanks for your suggestion! That solves one problem. Would you mind weighing in on another? Whenever the subreport that populates the detail section contains more rows than can fit on a page, the entire subreport populates on another page. In other words, page shows the page and...