I want the message to abort so i added the '1’
When using '0’ it warns and everything is ok
See also live error log
Is this a bug?
I want the message to abort so i added the '1’
When using '0’ it warns and everything is ok
See also live error log
Is this a bug?
Hi Theo,
Can you give us a little more insight? Is this message placed in the Default logic or another logic type? What does the whole code look like? Are there any other error occurring?
Mark,
It's a trigger
if exists (select 1 from inserted i where egtin_col] is not null and len(ngtin_col]) >0 and len(ngtin_col]) <> 14 and len(ngtin_col]) <> 13 )begin exec dbo.tsf_send_message 'gtin_length_not_valid', null, 1end
Ah, I see. The (after insert) trigger is not the best place to handle this kind of logic as you want to prevent the insert/update from happening. I do think the behavior is intended.
I suggest using a Handler instead. With a handler, you have full control over the processing of the data. You can let the Insert/Update/Delete statement be generated by the Software Factory and only focus on the added business rule logic, such as throwing this message. Could you try that?
Mark,
But it's a dynamic trigger for more columns. Now i have to repeat this for every column.
Mark,
The docs are clear about this. I still think it's a bug
Trigger or Event based logic is performed around the data manipulation. This logic concept is highly platform dependent. It offers the following possibilities:
Perform actions as a result of (attempted) changes in data
Prevent or undo changes in data (control)
In general, the concept can be divided into three types, with three moments per type. The available context is different for each type.
Instead of / before / after performing a create action - The field values of the record(s) to be added or that have been added.
Instead of / before / after performing an update action - The old and new field values of the record(s) to be changed or that have been changed.
Hello
To clarify, are you experiencing a functional problem as well or do you just want Indicium to not log an error in this case?
If you are experiencing a functional problem, can you elaborate on what is happening?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.