Search results for query: *

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

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

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

Hello, I have a query that joins 3 tables. I created a form with fields from each of the three tables using the Select query. When I click in the form field to add or change the data, nothing happens. How do I postback to the table from a form? Is there a table, form, or field setting to...

Greetings, I have three tables. I joined them using a select query. I created a form with the query as the source. When I open the form, I see the values from the tables. But when I click on a field to update the data, nothing happens. I need to update the field and write back to the table...

Greetings, I am reading in a field from a database that has a value such as "1|3|4" or "2|7|4|9" What I need to do is have several check boxes on a report and if the string has a 3, then check box #3 will be visible and checked on the report, and the same for check box #1 it will also be...

During print preview and design view when I mouseover a text box, the field name and table name appear in the status bar. In the active x viewer it displays next to the cursor. How do I supress this. I do not want viewers to see the table names in the viewer. There does not seem to be any...

I NEED TO HAVE A CHECK BOX OBJECT THAT CAN BE SELECTED BY CLICKING THE MOUSE ON IT. IF YOU CLICK THE EMPTY &quot;CHR(111)&quot; CHECK BOX THEN A CHECKED &quot;CHR(254)&quot; BOX WILL APPEAR ON THE CRYSTAL REPORT. THEN WHEN THEY PRINT, THE BOX WILL PRINT OFF AS CHECKED. THIS WILL ENABLE THEM TO...

HOW TO GET A FORM NAME THAT IS CURRENTLY LOADED, VISIBLE. I AM TRYING TO GET A VALUE FROM A FORM WHEN I DONT KNOW WHICH FORM IS OPEN, BUT BOTH FORMS THAT COULD BE OPEN HAVE THE SAME NAME FOR THE INPUT BOX THAT HOLDS THE VALUE. example : frmFORM1!txtInput.value...

This code is not working. It does not determine if the form is loaded. Keep getting message cant find frm..... Private Sub Command26_Click() On Error GoTo Err_Command26_Click Dim stDOcNAme As String If Forms!frmEOBGROUPS.Visible = True Then With Forms!frmEOBGROUPS...

This syntax is not working, get error message needing more ((())). Any ideas how to set this up right. thanks alot. rm if {GROUP_DAYS_SUPPLY.DAYS_BP1} is null or ({GROUP_DAYS_SUPPLY.DAYS_LIMIT}*{GROUP_DAYS_SUPPLY.MAX_FILLS}) < {GROUP_DAYS_SUPPLY.DAYS_BP1} then &quot;1&quot; else if...

i WILL BE PASSING IN A PARAMETER FROM AN ASP PAGE FOR GROUP NUMBER, THE CASE STATEMENT SHOULD THEN EVALUATE AND DISPLAY THE CORRECT IMAGE ON THE REPORT. NOT SURE IF IMAGES NEED TO BE IN A DATABASE OR NOT. ALSO, THE BASIC CASE STATEMENT GETS ERROR MESSAGES. DO I NEED SEMICOLONS AND WHY? tHANKS...

I added a second page header, inserted a picture &quot;confidential.bmp&quot;, checked Underlay Following Sections on the section expert tab. The problem is where I placed two horizontal lines across the report to highlight group header labels, the lines do not show through the...