>>
>>I have some reservations with this method when moved to the server? How are you getting the data back and forth to be validated, especially when validating the entire record rather than just a field?
>
>Hi Craig,
>
>The data itself *NEVER* moves anywhere.
>
>The only thing that moves are the actual validation(s) themselves (ie, "NOT EMPTY( ) AND # 0" or some such). This makes validating one field or one record basically the same operation, different only in the number of rows returned by the SELECT statement or parameterized view.
>
>Evan Pauley


What do you mean "the data never moves". Here's the scenario. The validation routines run on the server. I enter a record and click the Save button. Validation needs to take place. I need to validate individual fields AND the entire record. Are the validation routines accessed via DCOM? How does the data get to the server to be validated?

Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer