-
Hi THere,
I am trying to insert data into an oracle database through a form I am creating. The questions I have are as follows:
- at what level should I put the trigger that does the insert. At the moment I created an insert at the button level with the "when-button-pressed" trigger, but it does not work. It freezes up when I press the insert when I run it.
- The "ID" column which is my primary key as only the basic constraints like NOT NULL. How can I icrement it upon insert? I am supposed to have a pre-insert trigger? at what level?
- I have a primary key that is to be incremented and therefore I created a sequence. I am ommitingthe primary key in the insert. Am I supposed to have another trigger somewhere to increment the ID value??
Thanks
Dee.
God Bless
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|