MVSFORUMS.com

[jajularamesh]

i want to validate a date field by putting check constaint(i,e the date entered should be greater than the current date).when i am doing like this the query is not getting executed.

datedd constraint con_datedd check(datedd <= Current date)

[kolusu]

jajularamesh,

Check Constraints need to be a fixed value instead of a dynamic value. You cannot have current date which is a dynamic value as a check contraint. You can code an editproc on the column.

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

[Cogito-Ergo-Sum]