>>
>>
>>if alias.field2 < alias.field1
>> ** invalid, please re-enter
>>endif
>>
>
>So if I have a view "updatemeters" would the syntax be:
>
>IF updatemeters.prev_reading < updatemeters.new_reading
> WAIT WINDOW "HEY! your Reading is faulty"
> ...
>ENDIF
>
>is it best to put this in the valid or the beforerowcolchange or afterrowcolchange???
>
>Thanks
It's up to you, depending on if there are other fields in the same row that rely on this field, you may want to include in the actual valid... If not, the BeforeRowColChange() would be fine.
Also, Barbara Paltiel had the note of buffered views that while on the record, the value in the buffered table fields might not be the same as the currently edited value. If this is the case, you might want to pre-commit the changes to the buffered table by doing a GO RECNO(), then test the values on the table.