next question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: next question

  1. #1
    Join Date
    Apr 2001
    Location
    Germantown, MD
    Posts
    14
    I'm developing a form that has a master and detail block to assign instructors to classes. I have developed a
    push button that will update the new table with the class and the instructor assigned. I'm having trouble writing the trigger "when button pressed". I have used an select into statement and insert into statement and nothing will compile to update this table. Can someone offer some suggestions.

  2. #2
    Join Date
    Aug 2000
    Posts
    462
    You don't need any button or sql update statement. If you used the data block wizard to connect to your database (even if you connect to a non-Oracle DB), the default functionality will insert the records appropriately. Simply allow the users to insert rows into the child table by editing text items in the form. Of course, if the instructor does not yet exist, it will be necessary to insert and save the instructor before attempting to add a class to that instructor . . .

    If that doesn't help, email the fmb to me at oracle_dev2000@hotmail.com and I'll get into it for you . . .

    Just let me know in more specific form the functionality you seek.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width