Recent content by PatrickB101

the program is not giving an error it just doesn't seem to care what value your inputing it stiill gives you an alert. No matter if its a good value or a value that is a duplicate.

How can the duplicate record exists and I not know it. It displays all the records. It gives the alert even if you put it back to the original value.

oops actually i got this when others then close c; --alert_button := show_alert('LESSTHAN3'); --raise form_trigger_failure; -- place your code to process here end;

declare dummy varchar(5); alert_button number; cursor c is select 1 from KBI_VALID_VALUES where KBI_VVL_VALID_VALUE = KBI_VALID_VALUES.KBI_VVL_VALID_VALUE; begin open c; fetch c into dummy; if c%notfound then close c; else raise dup_val_on_index; end if; exception when...

i put this in a when validate item trigger is that correct?

it is giving an error on everything no matter if it should or not.

hmm well i got it to compile right it still does not work right i want it to give an error when the value is the same as a value that exists. and i don't want the code to do anything if it is a distinct value.

already fixed thanks for your help man :)

this is not compiling right cursor c is select 1 from KBI_VALID_VALUES where KBI_VVL_VALDID_VALUE = :KBI_VALID_VALUES.KBI_VVL_VALDID_VALUE.

Not Letting the user input a value that already exists.. I am not sure I have done sever vb programs nothing to do with database programs.. So bear with me. I understand i need to do this in a when validate item trigger. do you know what the syntax for if item equals a item that already exist...

Not Letting the user input a value that already exists.. I am not sure I have done sever vb programs nothing to do with database programs.. So bear with me. I understand i need to do this in a when validate item trigger. do you know what the syntax for if item equals a item that already exist...

hmm... are suggesting creating another table importing all the data from the ascii file into it. Then copying it over to my actual table doing the integerety checks on that transfer?

I have an ascii file i need to load into my data base.. I have some examples on what the code is.. but here is my problem . (simple for a dba I am sure) :) I need to have criteria and what I mean this, is ascii file is off a mainframe. The mainframe has no integrity checks.. so a table that...

do :new and :old just work in a database trigger?

i am trying to build a botton on my form with oracle developer that does this if :old.colname <> :new.colname then :storecolname := :old.colname end if; but all the examples I have seen where this work are database triggers not a &quot;when button pressed trigger&quot; so i was wondering if new...