Yak Posting Veteran
Posted - 09/30/2013 : 14:50:12
| Please i get this error statement after i execute the syntax below. Can someone help me out. And i created a rule and the rule is, and i binded the rule to the table and when i try to insert values into the table i get this error message all stated below respectively.
INSERT INTO SUPPLIER_SUPPLIERDETAILS (FirstName, LastName, Address, Phone, Country)
VALUES ('Babel','Lebab','5th melon street','125986324','Adisababa')
CREATE RULE PATTERN_RULE
@VALUE LIKE '_-%[0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9][0-9]-[0-9][0-9][0-9]-[0-9][0-9][0-9]'
EXEC SP_BINDRULE 'PATTERN_RULE','SUPPLIER_SUPPLIERDETAILS.[PHONE]'
Msg 513, Level 16, State 0, Line 1
A column insert or update conflicts with a rule imposed by a previous CREATE RULE statement. The statement was terminated. The conflict occurred in database 'HERESHOP', table 'dbo.SUPPLIER_SUPPLIERDETAILS', column 'Phone'.
The statement has been terminated.