-
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
-
Have you tried the ado schema or the adox methods to get the ..... oops! meeting time , I'll be back .....
-
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....
-
You can use ADO OpenSchema to get table constraints. Please read MSDN library for detailed information.
