Recent content by mstrong

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...

Thanks for both posts. I actually tried the first one and it did the trick for me. Thanks guys! Mike

That's an interesting idea. I'll give it a shot. Thanks!

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...

Yeah, checked those already. I can definitely see all of the other schemas through other apps (ms access, Excel) using the same ODBC, so it's definitely an interaction with CR10 and that driver.

That didn't do it. I can't see this schema even creating a new report and logging out of/into the server.

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...

Thanks for the quick responses. I was testing the first one when I saw the second. I'll check them both out for speed now. Thanks again! Mike

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...

For some reason, the "display one per page" didn't actually show any per page. I then tried out LB's idea and it did the trick perfectly. Thanks for the quick responses guys! Mike

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'll pass both of those on. Thanks for the advice.

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...

That did the trick. Thanks for the help guys.