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 Chriss Miller 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. anniez

    Closing Property Window

    When I switch from design view to form view, the property wiindow stays open. I don't know how this got set but please tell me how to 'unset' it. Thanks
  2. anniez

    Inserting sequential numbers to existing table

    I have a table with 12000+ records, many duplicates. EmpID, Date, Amt... I need to add a field (record_number) and populate it starting with 1.. to make it a unique row. I can add a sequence for future additions but can you tell me how to fill it now?
  3. anniez

    to_number

    ...automatically. If the value is over 100, the program has to 'do something' The field could be alpha or numeric. YOR ACE 30 30 YOR 190 YOR Select * from File where to_number(unit) > 100 I'd want it to return the 190 record but it returns nothing. Is there another function that would be...
  4. anniez

    trigger - updating from another table

    I totally agree with you. May I ask another related question here or shall I start another thread? The trigger works great but it isn't what I needed. When a patient is admitted here, our local patient table gets updated. Among other fields, status is 1 for inpatient, 2 for clinic...
  5. anniez

    trigger - updating from another table

    Thanks - I can't believe how easy you make it seem. Thanks also for the advise. However, one clinic could have several codes (sections). ex. Noyes Clinic could be 551, 552, 651 or 652. Staff generating reports are apparently not capable of relating tables so I was told to enter the clinic...
  6. anniez

    trigger - updating from another table

    You've helped me before with a similar situation but I just can't get this one working. When a clinic_number gets changed in table_A, the clinic_name also needs to get updated (unless the clinic_number gets changed to '000'.) Table_B contains clin_num and clin_name. I've tried many variations...
  7. anniez

    Scheduled append from Access into Oracle

    How can I schedule an automatic file update from an access file (on a Novell server) into an oracle table? From the Oracle side? Have the windows scheduler run sql that will truncate and insert? From the Access side? Run a query that will append into the linked Oracle table? It's being...
  8. anniez

    combobox - refresh form

    Thank you! Thank you! Thank you! That is exactly what I needed - and so simple. FYI-I do name the comboboxes to reflect their data in the applications.
  9. anniez

    combobox - refresh form

    On my form, (access 97) combo1 selects dept. Combo2 selects employees who are in that department. It looks beautiful the first time but if I select, another department, it still only show those in the department originally selected. Is it a repaint? requery? After update of combo1? I've...
  10. anniez

    Using INSERT INTO SELECT in a TRIGGER

    I have an update/insert trigger that needs some help. before insert on table referencing old as old new as new for each row begin update tableb set a=:new.a b=:new.b etc where id+:new.id and (:new:code=1 or :new.code=2) if sql%rowcount=0 then insert ..... end if; end; How do I update if...
  11. anniez

    update field if :new.field is not null

    I have a trigger that, if it can't find a match, inserts a new record in TableA with all the data from the new record in tableB. If it finds a match it should update field a,b,c,d,e... with :new.a, :new.b, :new.c, :new.d, :new.e... but only if the new a,b,c,d,e... are not null. SET...
  12. anniez

    trigger

    You just made me very, very happy. Thanks Annie
  13. anniez

    trigger

    ok - I've spent way too much time on this - as well as all of you. Maybe I'm on the wrong track. I still get an error. When someone leaves, we change their status to '0' I want their dept and bldg each set to '000' so the user doesn't have to do it. It's only done on one record - in the same...
  14. anniez

    trigger

    I hope this is my last message... I really don't know where the := goes. IF :NEW.FIELDA :='0' THEN :NEW.FIELDB :='000'; :NEW.FIELDC :='000'; END IF; ??????? Sorry for being so dense about this.
  15. anniez

    trigger

    Am I missing something? Now I get PLS 00103: encountered the symbol"=" shen expecting one of the following..... CREATE OR REPLACE TRIGGER ABCD.TRIGGERNAME AFTER UPDATE OF FIELDA ON ABCD.TABLENAME REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW BEGIN IF :NEW.FIELDA='0' THEN...
  16. anniez

    trigger

    I still get ora-04079 error: create or replace trigger trigger_name after update of fieldA on abcd.tablename if :new.fielda='0' then :new.fieldb='000'; :new.fieldc='000'; end if;
  17. anniez

    trigger

    I don't know why I'm having so much trouble with this! When fieldA gets changed to "0" I want fieldB and fieldC to get changed to "000" if :new.fielda="0" then update table.fieldA="000" fieldB="000" end if;
  18. anniez

    Query criteria - combobox

    When the query filters on "Like [...]" for the criteria, a blank text box pops up. Isn't it possible to have a combobox there instead? I've filled in the field properties as though it's a combo box but still get a text box. I know I can base the query on a form that has a combo box -...
  19. anniez

    Displaying Query Results on Form Locks the Records

    I have a file with patient info and one with employee info. PtFile has column called unit. EmpFile has columns userid and ptunit. My query filters the EmpFile to the network userid. The relationship limits the records to whatever unit in the PtFile matches the ptunit in the EmpFile. It sees...
  20. anniez

    Updating from 2nd table when trigger updates table

    I have a trigger that updates several columns in tableA with new employee information including DeptCode. tableB has Group and DeptCode. AUD 211 AUD 210 AUD 390 ISM 110 ISM 490 REL 333 REL 334 Can I update the group from TableB for a matching deptcode in the same trigger? Can you help me with...

Part and Inventory Search

Back
Top