Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
boomboom
Starting Member
6 Posts |
 Posted - 2004-06-23 : 14:45:04
|
| How can I add field level validation to a table? Basically what I want to be able to do is this:I have an application that has say about 20 fields on it. When I do an insert or modify of the data, I want to make sure that some of the fields are filled with correct data. I could do this validation inside of my application, but I'm looking for something that's a little more friendly to the end user so that their DBA can go in and possibly change the validations. I also don't really want my application to have to go and grab data from tables to populate dropdown lists with valid data.Am I looking at creating stored procedures for this or is there some other field level validation that I can within SQL Server?I also need to make this compatible with Visual Fox Pro .. so whatever I do in SQL Server, I need to be able to replicate somehow in VFP.Thanks for any suggestions. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-06-23 : 14:46:37
|
| You should be doing the validations with constraints on the columns. I would research constraints in SQL Server Books Online.Tara |
 |
|
|
|
|
|
Field level validation