Search results for query: *

Hi, I have a database that has several text fields, which I'd like to auto-populate by using a customer number (manually entered) to look up the relevant fields in an Oracle DB. I got to the point of getting a query to import the data, but I don't see a way to say "where...

Hi, I'm using CR10 to write a report which will be set up as a recurring report, to run on the first day of each fiscal period (using a custom calendar in CE10). I need this report to pull data for the previous fiscal period. I have a table that has dates, fiscal months, years, etc, which I...

Hello, I'm trying to write a report in CR10, using the Oracle-provided ODBC driver (v 9.02.00.65), hitting an oracle 9i database. My problem is that I can't see all of the schemas I need to. For example, I can see mine (MSTRONG), but I can't see the YCCDBS schema. I think the last time this...

Hello, I think I have a simple question, but it's driving me crazy. I have to update a column in a table that has 97 million rows. The update is basically set status=Y where status=X. I'm trying to do a plsql block that will keep a counter, and commit after every 1000 records, but I can't...

Hello, I'm trying to set up a report to run using a dependency (in this case a file either exists or doesn't exist). I see a lot in the Help docs about how to pick a dependency, but nothing on how to actually create one. I'm using Info Desktop 7.5 with Reports 8 (we're upgrading to 10 in...

Hello, I'm using CR8. I have a report that has several groups, with at least 2 sub-groups in each one. I'm trying to conditionally have the $ appear on the first row of records (9 different fields) of each page. I've created a conditional formula which looks at the recordnumber, and prints...

I'm helping out on a project that uses Cron to go out and get a file, which is then processed through another program. The current setup has a script that tests to see if a file is there, but it may still be open and being written to. We're looking for a way to find out if the file is open (or...

Hi, I'm trying to write a k shell script that will prompt the user for a location, and then pass that value to a stand alone sql that the script will call. I've done this with Oracle before, but the same method isn't working. This is the way I've approached it so far: echo " Enter...