Validation Rule

  • Thread starter Thread starter Tausif
  • Start date Start date
T

Tausif

Hi All GURUS,
I have a table name CustomerSystem where I have stored Purchase_Date and
Warranty_Expiry dates. I would like to put a validation rule at
Warranty_Expiry i.e. it should be greater then Purchase_Date. I tried
[Purchase_Date] its giving me error Invalid Sql Syntax - Cant use multiple
Click to expand...
columns at column level CHECK constraint.

How to define such validation rule?

Tausif
 
Try to create Validation rule at table level but not at the field level. Use
following as reference.

http://www.kbalertz.com/209106/Table.Field.Validation.Causes.Error.aspx
Tausif.

Tausif said:
Hi All GURUS,
I have a table name CustomerSystem where I have stored Purchase_Date and
Warranty_Expiry dates. I would like to put a validation rule at
Warranty_Expiry i.e. it should be greater then Purchase_Date. I tried
[Purchase_Date] its giving me error Invalid Sql Syntax - Cant use
Click to expand...
multiple
columns at column level CHECK constraint.

How to define such validation rule?

Tausif
Click to expand...
 
Back
Top