Recent content by mibeach7

yes that worked perfect! Big Thanks!

greetings I have this sql and want to count/group by. SQL> select SUBSTR(msg, INSTR(msg, 'ORA-', -4),9) as ERR FROM sysman.mgmt$events where MSG like '%ORA-%' and rownum < 6; ERR ------------------------------------ ORA-12505 ORA-12505 ORA-12505 ORA-28000 ORA-28000 Group by fails select...

Yes this worked! SQL> select SUBSTR(msg, INSTR(msg, 'ORA-', -4),9) as ERR FROM sysman.mgmt$events where MSG like '%ORA-%' and rownum < 6; ERR ------------------------------------ ORA-12505 ORA-12505 ORA-12505 ORA-28000 ORA-28000

I would like to extract all "ORA-" errors from OEM then group by and count by error code. Here is the text: SQL> select SUMMARY_MSG from sysman.MGMT$INCIDENTS where SUMMARY_MSG like '%ORA-%'; Failed to connect: java.sql.SQLException: Listener refused the connection with the following error...

Hello, The problem is I have two recordsets. I need to leave one open while I run another against it. I get an error due to the cursor location. I am writing out 1 header record with recordset rsHeader using Q1, and writing out multiple detail records using recordset rsDetail using Q2. Then...

I want to create one outfile in ASCII like the layout below, from one infile. Write out Header record with rollup totals(from the detail), then write out detail record for all claims for that day for each person. The detail is Grouping by date and by person. Do I need to use Collection Ojbect...

Greetings, I have 4 reports with VBA code behind them that checks boxes on each report based on a table value for each row. I am able to pull up each report manually and print to the printer. The problem: I added the 4 reports to a macro to open report and print. Then added a button to a form...

Greetings, I have an ASP site with Oracle and several Crystal Reports created. What I need is to be able to pass a query from Oracle into the Crystal Report using ASP (I can do all this) then Create the report and Archive it in .pdf format WITHOUT using the activeX or java Viewer. In other...

Hi All, I have a date text box with an input mask of 99/99/999 But the text box is blank until I click on it to enter a date. Is there a way to display the date format in the text box before the entry. Also, how to when the input box is clicked, the cursor will start at the first character...

Yep, that would do it for me. danka

Hello again, I have three tables all with a date field. When user enters a date into a text box, I want to click a button to insert a new record and the date value into 3 tables, all in the same query. Do I have to open a recordset for each table .Addnew function. Private Sub...

Greetings, I have a database with 200 reports, and most have images on them with various paths, either network or local. I need to know all the paths for all the images on all the reports in the database. I ran the Tools-Document-Analyzer and selected Reports. The problem is I get all this...

Go to desing view of the the query. Then select the leftmost toolbar icon, next to the save. then drop it down and select SQL view. Copy and past this into this thread so we can analyze it. Otherwise we are just guessing.

Microsoft Knowlegbase Article 244661 blah, blah blah... "Oracle 8.x-specific data types, such as CLOB, BLOB, BFILE, NCHAR, NCLOB, and NVARCHAR2, are not supported by Access" Go .Net Baby

Hi Peggy... You will need to modify the properties of the button. You will need to add an Event to the button. 1.Click on properties for the button. 2.Click the Event tab for the button. 3.On the line labeled "On Click", select [Event Procedure] 4. Here you can create a recordset and type in...