|Home » Elevate Software Blog » Casual Friday for Week Ending April 23rd|
CREATE TRIGGER "InsertError" ERROR INSERT ON "customer" BEGIN -- Check for constraint error (1004) and test to see -- if the primary key column CustID (VARCHAR) is blank IF ERRORCODE()=1004 AND NEWROW.CustID IS NULL THEN SET NEWROW.CustID=''; RETRY; ELSE RAISE; END IF; END
|Tags: Casual Friday||Permanent Link|
|Comments (1)||You must be logged in to comment|
|Bruno Krayenbuhl said...||Reply|
>to specifically run them as Administrator
On XP you can right click the installation .EXE do Execute as... then continue installation and you are prompted with Select a user ...
Doesn't it work on Vista and later ?