Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mibeach7

    Group by challenge

    yes that worked perfect! Big Thanks!
  2. mibeach7

    Group by challenge

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

    OEM extract ORA- from string text

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

    OEM extract ORA- from string text

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

    Cursor Location RecordSet

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

    Complex Output File String

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

    Print Report with Macro

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

    ASP ORACLE CRYSTAL

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

    Display Mask, Blink Cursor in TextBox

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

    Append 3 Tables with TextBox Value

    Yep, that would do it for me. danka
  11. mibeach7

    Append 3 Tables with TextBox Value

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

    Analyze Report Properties with Documentor

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

    Query returns two records for each row

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

    Blob data type

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

    Switchboard to run query

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

    Form Not Updating Tables

    I changed the primary keys to the joined fields. Created a new form addind the field from the tables without using the select query. And it works. Thanks guys for your help!!
  17. mibeach7

    Form Not Updating Tables

    Here it is. What I have is 3 tables, one for each hairstylist. I am creating a scheduler for each time slot that will hold the name of the customer. I join on date so I can view all the time slots for a whole day. On the form, I have all time slots for each stylist as text fields. SELECT...
  18. mibeach7

    Form Not Updating Tables

    Willir and TheAceman1, Thanks for the insite. I have three tables I am joining one to one on a date field. I do not outer join any of them.
  19. mibeach7

    Form Not Updating Tables

    TheAceman1, How do I post the query. In module? Maybe on form load I need to set it the recordset to update?
  20. mibeach7

    Form Not Updating Tables

    I changed the form recordset type to Dynaset (inconsistent updates). The problem is the form does not show the existing data from the tables, all the form fields are blank. Although I can add data to the form fields now. Where is the current table data? Is there another setting?

Part and Inventory Search

Back
Top