Cor Ligthert [MVP]
11/14/2007 6:19:00 AM
Kerry,
Maybe I am confused, however I see forever in the SQL Server Management
studio IDX files when there is created a constraint by the tool.
I avoid them as hell and do checking using the VB or C# code because
constraints gives for me only difficult to handle exceptions which come as
the user is completely finished with the things he has to do and does the
update of the dataset. As the constraint was fixed by the binding to the
controls (textbox etc), then this would be of course a great solution.
However this seems to me an impossibility. Because if you are doing it good
you don't have a full database in your dataset, but use almost forever where
clauses.
However, as I am understood it wrong ***Sorry***.
Cor