I perform validations on Save method and interactive... Due to the bug in VFP6, I have to create a workaround, which works fine...

>Nadya,
>
>Have you considered looping through the changed rows prior to committing the data and validating at that point, rather than trying to validate during data entry?
>
>If an invalid row is found, exit the loop, put up a message box informing the user that additional data is required (or whatever happens to be wrong) and set focus to the column that requires the user's attention.
>
>
>Jim
>
>
>
>
>>Hi everybody,
>>
>>Ok, now after I explained my frustration I hope to get some help on the following problem:
>>
>>I have a grid on a form to type additional mortgage info. E.g. each main sale/mortgage record may have up to 5 additional mortgage records.
>>
>>In the grid I have a method to validate user's entry. Some code is in BeforeRowColChange, AfterRowColChange, textbox.Valid, Valid method of the grid, etc.
>>
>>Everything seems to be working now except for the following:
>>
>>I have a validation, that if Lender is not empty, Mortgage should be not empty too. In addition, user must re-type Amount using separate form.
>>
>>Now this is that happening: I type amount, re-type it, then click in a control on a page (outside of the grid). I get a message, that Amount could not be empty if Lender is not empty. It looks like the Valid of the grid fires before the valid of grid's column textbox fires, e.g. the value, I typed, have not been written to the table yet, therefore this message is issued.
>>
>>How should I fix this problem? I suppose, in Grid's Valid event I have to ensure, that valid of ActiveColumn textbox already fired... Can you give me a hint, please?
>>
>>My manager just came and said, that DataEntry is my first priority, sorry...
>>
>>Oh, well...