Search results for query: *

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

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

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

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;

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

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

I have a trigger that, if it finds a matching record to update, puts in the current data. There is a date field that should be made blank. Can you help me with the syntax? set a=:new.a, b=:new.b, dscdate = ????? where id=:new.id;

I have two applications working quite well alone. I've been asked to have applicationA's switchboard have an option to open ApplicationB. Can a switchboard call another one?

I have a character field, UNIT. It could have any value from 000 to 999. I want to update the field, GROUP, to be "WBU" when UNIT begins with '3'. Do I use the substr() function within the decode? Something like this? group=decode(substr(:new.UNIT,1,1),3,'WBU') Thanks

Two files have the same unique idfield (each has many other fields - TableA has statewide data/TableB has locally maintained fields). Several other files have multiple records with this idfield in them. Often - A temporary IDfield is assigned on admission. When the real IDnumber is assigned...

I have a form with a field (Dept). I have a combo box with employees where employeeDept = forms.formname.dept. It works fine - if I put in ACCT for Dept, the combobox only shows employees in ACCT. If I add another record, change the dept to FIC, the combobox still has ACCT. Same if ACCT was...

Can you help me write the update statement: UPDATE TABLE1 SET FIELD1=:NEW.FIELD1, FIELD2=:NEW.FIELD2, WHERE TABLE1.EMPID=:NEW.EMPID to also update table1.curstat to 1 if :new.reason=2, table1.curstat to 2 if :new.reason=4, table1.curstat to 3 if :new.reason is...

My record ID is a number. In a query, it sorts fine (1,2,3,4,5...) until I add another table to the query. Then it sorts as though it's a character (1,10,11,,,2,20,21...) I need the data from both tables and I need it in record ID order. Help...

I have three tables (A,B & C). C gets refreshed every 15 minutes. If a new record is added, both A & B will be effected. If an IDcode isn't in those files it must insert a new record - it will have several columns in each table that would be completed. If the IDcode is already there, it...

I have a file that I can't access. I get (ORA 00054 resource busy and acquire with NOWAIT specified. ) I can't drop the table, rename it, add fields.... I have another copy that is usable but when I migrate it to this instance, I still can't use it. No one else is using it. What can I do...

Is the number of fields in a table limited in Oracle 8.1?