hi,guys
i have a question about how to create trigger.
when i use the Firebird .net Provider 5.0 . i dont kown how to create the
commandtext for trigger.
e.g
SET TERM ^ ;
CREATE TRIGGER TCURRENTSET_BI FOR TCURRENTSET
ACTIVE BEFORE INSERT POSITION 0
AS
DECLARE VARIABLE tmp
Download and use FlameRobin easiest way!
This message is intended only for the use of the individual or entity to which
it is addressed, and may contain information that is privileged, confidential
and exempt from disclosure under applicable law. If the reader of this message
is not the
You need to remove set term instructions, it is not actually part of the
Firebird syntax. They are only used by query tools like ISQL and Flamerobin.
So remove both set term instructions and the ^ after the final end and you
should be able to execute the create trigger using the .net provider.
hey,mark
thx for your reply.
i have already solve it.
maybe some questions when i use the function of FBscript.
anyway,thx a lot.
Regards
Chen
-- --
??: "Mark Rotteveel";;
: 2016??7??3??(??) 5:23