[Firebird-net-provider] some questions about Firebirsql

2016-07-02 Thread ??????
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

Re: [Firebird-net-provider] some questions about Firebirsql

2016-07-02 Thread stevyn dembo
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

Re: [Firebird-net-provider] some questions about Firebirsql

2016-07-02 Thread Mark Rotteveel
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.

[Firebird-net-provider] ?????? some questions about Firebirsql

2016-07-02 Thread ??????
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