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

...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 "like '123456*'".

...in the column is a part number like '123456', except that it is right padded to 20 characters by the 3rd part app we run...so it is really '123456**************', where * is a space. She swears that in access, when she did an advanced filter on that column, she needed only to enter the value...

...in the column is a part number like '123456', except that it is right padded to 20 characters by the 3rd part app we run...so it is really '123456**************', where * is a space. She swears that in access, when she did an advanced filter on that column, she needed only to enter the value...

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)"

...names returned by the query... for instance... Dim db1 As Database, rst1 As Recordset, sql1 As String Set db1 = CurrentDb sql1 = "select * from your_table where table_column= '" & Me!Combobox & "';" Set rst1 = db1.OpenRecordset(sql1) rst1.Requery If rst1.RecordCount...

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.