Search results for query: *

I would like to know if there is any way to increase the Oracle window size when using the web. I have a forms application that I have moved to the web. It looked great before I went to the web, now it is in the tiny window. Thanks!!!

Is there a way to check to see if you are closing the form before firing a trigger? In my form I fire a trigger to make sure all the required fields have been entered. If for some reason, the user decides they don't need this form and would just like to close it, I don't want the trigger to...

I have a main menu form, that calls another form. The main menu form, is only buttons - no data at all. However, the other form has a lot of data that is being updated. When I do a commit_form it commits the transactions and works fine, but when I go back to the maim menu form, it displays a...

Thanks for the suggestions. I will take a look at the flowcharts, and I am also going to check into the books you mentioned. I am definitely find out the true meaning of frustration. Thanks again!

Ok, I took the sequence off the field and was able to insert fine. Can someone tell me why the sequence was causing the problem?

Maybe you all could give me some suggestions on some books I can buy to help me. Thanks again!

No offense taken, I just didn't really know how to answer. I am going to try to figure this out. Thanks to everyone for your help!

Ok, I'm not sure what was meant by not understanding my requirements. But, I think I just need help figuring out how to get what I want. Thanks to everyone who has tried to help me. There is only one table on the form, but there are also additonal fields that I am using to get more...

Um, a little more explanation. This is an inventory program. Each time a user places an order, I subtract the number they ordered from the INV (INVENTORY) Table and update the remanding qty. The forms displays all the items in tabular form (so lets say there are 10 possible items they can...

I am very new to Oracle, so I am not sure what I should be using exactly. What would I do with the When-Validate trigger?? And, I am confused about the On-Insert trigger because if I do an insert inside the On-insert trigger what will cause it to fire?? Thanks!

Sequence number and not null.

Ok, the way that I am inserting into this table (the one with the sequence - it is named REQUEST) is: If a field in another table (named INV) is changed then I want to insert a record into the REQUEST table. Basically an Audit Table. Therefore, I do not have the REQUEST table on my form. I...

Thank you, I will try this first thing in the morning!

Yes, I am using sequence numbers and nextval. I ran the form in debug and I can see that the sequence number is changing and because I only have two records so far in the table, I can easily tell that they are not duplicates. However, I do believe the sequence number is my problem and am...

Undoubtably, Forms does not recognize this as an "Error" because even the DISPLAY_ERROR says "no errors encountered recently". When I try to insert it just says FRM-40735: Pre-Update (also tried Post-update and got the same thing) trigger raised unhandled exception...

Thanks for the suggestion, but when I use the shift-f1 key, it just says "no errors encountered recently". And, yes I am running a forms application. Thank you!

I am having a problem inserting into my table. I know that all the data is there because I ran the form in debug and I can see all the data on the stack. I keep getting an ORA-00001 error. Could someone please help me figure out what I am doing wrong. Thank you!

Background: I have two tables. One is listed tabular on the canvas. For each record on this table that is changed, I want to insert a new record into the other table with the changed data from this table. Ok, I was told to use a cursor to look at each record in table one and insert a new...

I figured it out. Thanks for your help!

I am new to Oracle. My first project is to create a program that will allow users to select "promotional material" to be mailed to customers, and also keep track of the current inventory. I am using forms to do this. The item number, items description and qty are all in a...