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
--- 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
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
If I insert duplicate rows, I assume the order of operations is:
Before triggers
Insert
Exception
After triggers -- never executed
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
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?
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)
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.
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
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
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
11 matches
Mail list logo