Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. mbrent

    Deploying on the Web

    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!!!
  2. mbrent

    Is there a way to check to see if you are closing the form?

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

    Commit_form

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

    Inserting problem

    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!
  5. mbrent

    Inserting problem

    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?
  6. mbrent

    Inserting problem

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

    Inserting problem

    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!
  8. mbrent

    Inserting problem

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

    Inserting problem

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

    Inserting problem

    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!
  11. mbrent

    Inserting problem

    Sequence number and not null.
  12. mbrent

    Inserting problem

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

    Inserting problem

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

    Inserting problem

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

    Inserting problem

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

    Inserting problem

    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!
  17. mbrent

    Inserting problem

    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!
  18. mbrent

    CURSOR/INSERT HELP!

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

    Update Database???

    I figured it out. Thanks for your help!
  20. mbrent

    Update Database???

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

Part and Inventory Search

Back
Top