Search results for query: *

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

is :old and :new just a database trigger?

is :old and :new just database triggers? if not may i see an example of how the code would look in a when button pressed trigger.. thanks

Is there away to change the text item box height in runtime? If it is possible to do this based on how many character are in that exact same text box? The box will contain records and I want the box to adjust automaticly depending the number of character in that record. On Another note I am also...

OK I got some screen shots. Thanks sem for the help. So are you saying that Records_Displayed cannot be changed at all during run time? You can see what I am talking about in prog3 and prog4. In prog4 there are 26 records. I want to make the records display (the table layout of the data) adjust...

The program is written in Oracle Developer data base is 8i If that helps.. would a screen shot help any?