How to call oracle triigers in vb

Hi,
I would like to know the syntax of callling an oracle trigger through visual basic 6.0.


Eg:Suppose there is a table named emp in oracle.....having all the employee details..At the time of inserting records into the table if the experience of the employee is less than 2yrs then a trigger should be fired that will automatically insert 2 instead of the text typed in the experience textbox in visual basic.



Can anybody help!!!!!!!!!!!!!!!!!!

Comments

  • : Hi,
    : I would like to know the syntax of callling an oracle trigger
    : through visual basic 6.0.
    :
    :
    : Eg:Suppose there is a table named emp in oracle.....having all the
    : employee details..At the time of inserting records into the table if
    : the experience of the employee is less than 2yrs then a trigger
    : should be fired that will automatically insert 2 instead of the text
    : typed in the experience textbox in visual basic.
    :
    :
    :
    : Can anybody help!!!!!!!!!!!!!!!!!!

    Couldn't you check the input from the user in your VB program and do the modification yourself? Or perhaps run a script in the Oracle database that looks for employees with less than 2 years experience and sets the correct column-value.

    Best Regards,
    Richard

    The way I see it... Well, it's all pretty blurry
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion