Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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