[firebird-support] Firebird trace config problem

2013-01-10 Thread karolbieniaszewski
Hi, i try to use new trace facilities but without success only what i got is trace init and nothing more in log file 2013-01-10T08:57:52.9230 (3628:0090DA30) TRACE_INIT SESSION_1 Firebird Audit regards, Karol Bieniaszewski my config look like this database

[firebird-support] Re: Firebird Windows 3.11

2013-01-10 Thread mariuz
--- In firebird-support@yahoogroups.com, Andy Gable wrote: Yes they would BUT I can only code in BASIC (QuickBasic for MS-DOS and Visual Basic for windows) -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Anderson

Re: [firebird-support] Re: Firebird Windows 3.11

2013-01-10 Thread Werner F. Bruhin
On 10/01/2013 11:14, mariuz wrote: --- In firebird-support@yahoogroups.com mailto:firebird-support%40yahoogroups.com, Andy Gable wrote: Yes they would BUT I can only code in BASIC (QuickBasic for MS-DOS and Visual Basic for windows) Have you already written the POS? If not or if it

[firebird-support] Unique key exceptions triggers

2013-01-10 Thread Rick Debay
If I insert duplicate rows, I assume the order of operations is: Before triggers Insert Exception After triggers -- never executed

Re: [firebird-support] Firebird trace config problem

2013-01-10 Thread Thomas Steinmaurer
Hello Karol, i try to use new trace facilities but without success only what i got is trace init and nothing more in log file 2013-01-10T08:57:52.9230 (3628:0090DA30) TRACE_INIT SESSION_1 Firebird Audit regards, Karol Bieniaszewski my config look like this database

Re: [firebird-support] Exception handling in loop

2013-01-10 Thread Thomas Steinmaurer
I want to select a bunch of items and insert them somewhere else. If the insert fails because of a duplicate primary key or unique constraint, I want to abandon that particular item and continue with the rest. This code outlines my logic. Is this correct for what I'm trying to accomplish?

Re: [firebird-support] Unique key exceptions triggers

2013-01-10 Thread Thomas Steinmaurer
If I insert duplicate rows, I assume the order of operations is: Before triggers Insert Exception After triggers -- never executed Correct. This can be easily checked with the Trace API. The execution order of the trace events are: EXECUTE_STATEMENT_START (insert into)

RE: [firebird-support] Exception handling in loop

2013-01-10 Thread Rick Debay
Since a block wasn't exited before the exception was handled, wouldn't any database statements in the block stand? Assume for a moment that it wasn't a constraint violation, but a table trigger throwing a custom exception, and the catch block handles it instead of handling constraint violations.

RE: [firebird-support] Unique key exceptions triggers

2013-01-10 Thread Rick Debay
Thanks, I'm trying to follow Arthur Conan Doyle's advice Once you eliminate the impossible, whatever remains, no matter how improbable, must be the truth and turn improbabilities to impossibilities. Rick DeBay -Original Message- From: firebird-support@yahoogroups.com

Re: [firebird-support] Exception handling in loop

2013-01-10 Thread Thomas Steinmaurer
Since a block wasn't exited before the exception was handled, wouldn't any database statements in the block stand? Assume for a moment that it wasn't a constraint violation, but a table trigger throwing a custom exception, and the catch block handles it instead of handling constraint

Re: [firebird-support] Need a little help with EXECUTE STATEMENT

2013-01-10 Thread SoftTech
Greetings Martijn and Mark, You're exactly right that fixed the problem. Mark it also fixed this error ISC ERROR CODE: 335544606 ISC ERROR MESSAGE: expression evaluation not supported Thanks to both of you for taking the time to respond, Mike - Original Message - From: Martijn