>>>
>>>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, I think we're talking about two different things here.

< The validation routines run on the server. >
Not in what I'm describing...the validation routines run *between* the VFP client and the back end server. They are *not* stored procedures...in fact, they would execute IN ADDITION to any stored procedures.

< I need to validate individual fields AND the entire record. >
What are you validating in the "entire record" that's not in one of the fields?

< How does the data get to the server to be validated? >
Again, it doesn't need to get to the server. What this "rules object" does is handle all the necessary "business rules" or "validations" (take your pick). The rules object does NOT handle referential integrity...that's the responsibility of the "server" or "back end", be that VFP or Oracle or Informix or SQL Server or whatever. The rules object works in *conjunction* with ANY stored code on the back end...in fact, in most cases, it would "confirm" the data from the client to be complete and in order before the actual "server" even knows it exists.

My apologies if I wasn't real clear on that previously .

Evan Pauley

Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?