Recent content by anniez

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

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?

A field (Unit - vchar2(6)) gets updated 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...

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

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

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

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

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.

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

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

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

You just made me very, very happy. Thanks Annie

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

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.

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