Database Constraint

[dvst8]

I have an SQL database, which has a table that has constraints on the data that can go in. (ie constrain is that numbers must be between 4000-4999).

what i would like to do, is find out the contraint programatically from ASP. can this be done?

the reason i want to do this, is so that if the user enters bad data, i don't want a bad ADO error thrown...

and i don't want to do client side validation, because the constraint may change....

please let me know if/how it can be done!

dvst8

[Cerksees]

Have you tried the ado schema or the adox methods to get the ..... oops! meeting time , I'll be back .....

[dvst8]

i posted the solution that i implement in the Database development forum. i don't think this is the optimal way of doing it...but it works!!

if you know of other ways, i'd be interested in hearing them.

i don't know anything about schema or adox....

[Learning]

You can use ADO OpenSchema to get table constraints. Please read MSDN library for detailed information.