description: add possibility to create exception definition for table

simple example
1. create exception 'Exception Name' on 'TableName'(FieldName, FieldName2) message 'Field % have wrong value for recordID %"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', 'ID') message 'Field % must be greater then 0 for recordID %"
Create Constraint CK_XXXXXX Check(Price>0.0) exception 'Exception Name'

1. more extended
create exception 'Exception name' on 'TableName'(FieldName, value 'FieldName', 'FieldName2') message 'Field % wrong value % for record ID"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', value 'Price', 'ID') message 'Field % must be greater then 0 current is: % for recordID %"
Create Constraint CK_XXXXXX Check(Price>0.0) exception 'Exception Name'

=>

add possibility to create exception definition for table

simple example
1. create exception 'Exception Name' on 'TableName'(FieldName, FieldName2) message 'Field % have wrong value for recordID %"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', 'ID') message 'Field % must be greater then 0 for recordID %"
Create Constraint CK_XXXXXX Check(Price>0.0) exception EPriceMustBePositve

2. more extended
create exception 'Exception name' on 'TableName'(FieldName, value 'FieldName', 'FieldName2') message 'Field % wrong value % for record ID"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', value 'Price', 'ID') message 'Field % must be greater then 0 current is: % for recordID %"
Create Constraint CK_XXXXXX Check(Price>0.0) exception EPriceMustBePositve

description: add possibility to create exception definition for table

simple example
1. create exception 'Exception Name' on 'TableName'(FieldName, FieldName2) message 'Field % have wrong value for recordID %"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', 'ID') message 'Field % must be greater then 0 for recordID %"
Create Constraint CK_XXXXXX Check(Price>0.0) exception EPriceMustBePositve

2. more extended
create exception 'Exception name' on 'TableName'(FieldName, value 'FieldName', 'FieldName2') message 'Field % wrong value % for record ID"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', value 'Price', 'ID') message 'Field % must be greater then 0 current is: % for recordID %"
Create Constraint CK_XXXXXX Check(Price>0.0) exception EPriceMustBePositve

=>

add possibility to create exception definition for table

simple example
1. create exception 'Exception Name' on 'TableName'(FieldName, FieldName2) message 'Field % have wrong value for recordID %"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', 'ID') message 'Field % must be greater then 0 for recordID %"
alter table costs add Constraint CK_XXXXXX Check(Price>0.0) exception EPriceMustBePositve

2. more extended
create exception 'Exception name' on 'TableName'(FieldName, value 'FieldName', 'FieldName2') message 'Field % wrong value % for record ID"

and use in eg. check constraint :
create exception EPriceMustBePositve on Costs('Price', value 'Price', 'ID') message 'Field % must be greater then 0 current is: % for recordID %"
alter table costs add Constraint CK_XXXXXX Check(Price>0.0) exception EPriceMustBePositve

priority: Major [ 3 ] => Minor [ 4 ]

Link: This issue is related to CORE736 [ CORE736 ]

Version: 3.0 Alpha 1 [ 10331 ]

assignee: Adriano dos Santos Fernandes [ asfernandes ]

Fix Version: 3.0 Alpha 1 [ 10331 ]

Version: 3.0 Alpha 1 [ 10331 ] =>

Link: This issue is related to CORE832 [ CORE832 ]

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Duplicate [ 3 ]

status: Resolved [ 5 ] => Closed [ 6 ]

Fix Version: 3.0 Alpha 1 [ 10331 ] =>