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

    Query Documentation

    This is something that I've been sort of struggling with for a while now. I work at a software company, and so the situation often arises where we need to tweak someone else's query or where down the road our own queries will need to be completely understood by others. So I'm wondering if...
  2. Felgar

    Nullable Key Field

    Thanks for the input everyone. I can definately see your point CRoberts. However, I'm not sure that I completely agree. The problem that I have with generated PKs, is that then I truly know nothing about the data. I can't count the number of times that I've been told, "This set of...
  3. Felgar

    Nullable Key Field

    Ok, my situation. I have a record that has a name, type, and third description field. Now, normally name and type will uniquely identify a record. So basically, for each name, I can have a "type a", "type b", "type c", "type d" record. But on...
  4. Felgar

    Should I Try Windows Scripting For This?

    I'll look into those. Thanks for your help.
  5. Felgar

    Should I Try Windows Scripting For This?

    Hmm, there are a lot of macroing programs out there that sit on the tray and detect keystrokes. Are you saying that they are all installing their own keyboard drivers? Perhaps that is the case, but I figured that it would be relatively simple given the number of apps out there that do this...
  6. Felgar

    Should I Try Windows Scripting For This?

    I have a problem, and I'm not sure the best way to solve it. First, I have a wireless USB keyboard, that uses native windows drivers. Don't expect this to come into play, but you never know. Also, I have a TV that I am trying to control with my computer. The idea is that there are picture...
  7. Felgar

    NULL problem

    I'm pretty sure that replacing if (ltrans_seq_num = null) Then with if (ltrans_seq_num IS null) Then will work. Any boolean expression that has NULL as a paramater will return NULL, which then drops you down to the else because the result of the IF is not TRUE. The IS NULL statement...
  8. Felgar

    Oracle - Access- Outlook

    I think DBMS Alerts are what you are looking for. I've never used them so I can't give you any code or anything like that. But the idea is to put triggers on the tables and columns you want to monitor for changes. The trigger can call a dbms procedure to raise the alert. In the application...
  9. Felgar

    Couting Problem

    Yes Carp, that would work. It would probably be better doing that than trying to clean out the table and re-populate it each time. Even 50 years of days is only 18K records. Plus, it then removes the need for table locking and multi-user considerations, because the table is fixed. And in...
  10. Felgar

    How do I return a sorted top ten list?

    I have not yet tried this, as my Oracle server is in the midst of being reinstalled and is currently not available for me to use. However, I am fairly sure this will work. select * from employee E1 where 10 < (select count(*) from employee E2 where E2.startdate > E1.startdate) order...
  11. Felgar

    Couting Problem

    Jimbop: Yes, this may be the only way to do it. But ultimately I am trying to run a query for a report, which requires a recordset. My front end is delphi, so if I can get the job done using only a query then it's preferable because the dataset component then becomes very simple. Worst case...
  12. Felgar

    Couting Problem

    I have a situation where I have a record that has an effective duration, based on days. Ie: There is a start and end date for the active period of my entity. I need a query to generate a set that spans the record over each day that it is active. For instance, if it is active from Jan 5 to...
  13. Felgar

    Monitoring Oracle Procedure

    I am fairly familiar with the SQL monitor. It basically tells you what data/messages have been passed between Oracle and your application. For instance, when invoking a stored procedure, the monitor will show the values of the paramaters, etc. While useful for many things, the SQL monitor...
  14. Felgar

    Monitoring Oracle Procedure

    I have an application that uses a fairly extensive Oracle database. Each month the user will run a summary process that will take all the data for the prior month and create summary data which is then used for various purposes. My problem is that the procedure to fetch and load the data has...
  15. Felgar

    Check if a form is open

    Hi, I have a form (CandidateSearch Subform) that uses a query as it's datasource. The query has paramaters that come from a second form (CandidateSearch), and these paramaters are used to decide what records to include in the query and therefore to show in the results. The names are...
  16. Felgar

    Editable Reports

    I am probably posting this message to the wrong forum, but I wasn't sure where else to place it. I have a situation where I need the capabilty of a reporting tool, but I would like the ability to be able to open the report and edit it as if it were a regular document, once the report is...
  17. Felgar

    Temp string in text box?

    I am attempting to write an autofill routine to make a best guess from a list of values that are stored in a table. (much like netscape will do for urls when you type them in the location bar). I'm stumped because I don't know how to reference the data that is being typed in while they are...

Part and Inventory Search

Back
Top