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

    filter problems in Access 97 linked to Oracle 7.x database...

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

    Timed Triggers

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

    AARRRGGHHH!!!! Still can't get the linked table thing to work!

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

    links to Oracle

    ...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*'".
  5. Nebuchednezzar

    links to Oracle

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

    filter problems in Access 97 linked to Oracle 7.x database...

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

    Prompting to change user passwords

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

    Datalink views?

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

    Importing Exporting data from Orale 8.0

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

    Creating Stored Procedures

    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).
  11. Nebuchednezzar

    Notify of duplicate value in field before going to next form

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

    DECODE different things

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

    Combo Box

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

    Cron export failing with no message file error

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

    transfer or migration data between diferent structure databases

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

    select from Date data type table column

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

    transfer or migration data between diferent structure databases

    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)...
  18. Nebuchednezzar

    Selecting only the latest date

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

    Selecting only the latest date

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

    svrmgrl problem

    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.

Part and Inventory Search

Back
Top