Search results for query: *

Thanks for the reply... Based on her statement that it changed within the last week, I imported the table in question from an export taken in mid May...The table structure is the same, and all the data is blank padded just like it is now. Thanks though...I think that answers the question that...

Use dbms_job...not a trigger. A trigger causes something to happen based on another event occurring. sounds like you are just wanting a process to occur on a timed basis...not based on another event occurring.

This may be a round-a-bout way of doing it, but how about... Public Function CvtEmpName(strIDNo) ' Converts an employee number into a name Dim db as currentdb Dim rst as Recordset set rst = db.openrecordset("SELECT EmployeeInfo.FullName FROM EmployeeInfo WHERE EmployeeID =...

hmmm. thanks for the reply, but unfortunately, it doesn't help. If it does work, I need to know why it is not working for me. I've created a new table with a varchar2(20) field and it does the same thing. (it will not find the record when doing an advanced filter unless my criteria is...

Ok...I'm just looking for someone to back me up here... My boss loves to use Access97 to link to Oracle tables. Recently, she has said that the advanced filter option in Access is not working properly, and therefore, the structure of our Oracle tables MUST have changed. Here's the deal... One...

Ok...I'm just looking for someone to back me up here... My boss, for some reason, loves to use Access97 to link to Oracle tables. Recently, she has said that the advanced filter option in Access is not working properly, and therefore, the structure of our Oracle tables MUST have changed...

Well, if you are going to be storing user passwords in a table, just add a column to that table to store the date last changed (when a user changes their password, update the table with the current date (now function). Then, when they login each time, check the login table for the date...if it...

One advantage I've found in defining views for remote tables is security... I don't want certain users connecting to my remote database, so I set up a local view which uses a link to select from those table(s)...then give select rights to that view. Also handy when we need to write reports...

There may be an easier way that I'm not thinking of, but my suggestion is this... Since you are pulling data from multiple tables on the source database, and you aren't wanting all records, I would do this... create a script to select the rows you want, delimit fields by pipe symbol(|) or comma...

the most basic procedure creations syntax looks like... CREATE PROCEDURE your_procedure_name IS BEGIN ... END; / Notice the keyword IS... (You can substitute the work AS for IS above - they are synonymous when used here).

you could put some code in the 'on exit' event for that field that queries the table in question for that value... if it exists, display a message box and clear the field or something.

How about... "DECODE(trim(to_char(:CODE)),'',null,'-111',null,:CODE)"

If your other columns are bound, you could use the value of the combo box to determine the value to use in a .seek method against the primarykey of the table. look up seek in help to find out the details. The other option is to attach a query to the afterupdate event of the combo box using...

Is the cron run under the oracle unix user, or another user (root, etc)? Log in under the user whom the cron is launched under, and just try typing exp and hit enter. Make sure that the exp executable itself is executing correctly. If it isn't, it is probably a rights issue...

Say you have a table on the old database with the structure... ID NUMBER, NAME VARCHAR2(20), ADDRESS VARCHAR2(40) and the structure of the table you are inserting into is... ID NUMBER, NAME VARCHAR2(30). If you have a database link, you could just run...

Be sure the field you are selecting from is in fact a date datatype (describe the table)...if it is actually stored as a char or varchar, the query would need to be written differently.

This is a query which will generate an additional sql statement for you (a bunch of separate insert statements for all rows which could then be executed. The || character means concatenate (put to values together. In this case, it is taking the first string 'INSERT INTO DIAGRAMS (ID, NAME)...

If you're looking it up for a specific item each time, you can run... SELECT AUDIT.TRANS_DATE, INVY.DESCRIPTION FROM AUDIT INNER JOIN INVY ON AUDIT.ITEM = INVY.ITEM WHERE AUDIT.TRANS_DATE IN (SELECT MAX(TRANS_DATE) FROM AUDIT WHERE INVY.ITEM = "1"); --in the above, you could use a...

How about this... select * from your_table where your_table.datefield In (select max(datefield) from your_table where itemno = "your_item_no");

Also, be sure that when you pulled the files off tape, that they aren't all owned by root. If they are, either change the ownership of oracle-related files back to the oracle user, or grant executable rights to the oracle user using chmod.