> parameter cColName > cValue = proper(eval(cColName)) > do case > case cColName = 'ADDRESS_LINE_ONE_TX' > ? 'Column Name - ' + proper(cColName) > ? 'Column Value - ' + cValue > replace &cColName with cValue > endcase >return .t. >>When I make a change in the column, I now get an endless loop. I think VFP is constantly replacing the field. Can you think of a way to make it just replace once?
* Stored procedure * Table validation for Table1 : myTable1CheckRow() function myTable1CheckRow local ix scatter name oVerifier for ix=1 to fcount() myTable1ColCheck(field(ix)) endfor gather name oVerifier * Further rowwise check function myTable1ColCheck lparameters tcColName do case case inlist(tcColName,'FIRST_NAME','LAST_NAME','TITLE') store proper(eval('oVerifier.'+tcColName)) to ('oVerifier.'+tcColName) *.... otherwise *... endcaseIf nonbuffered would fire with every field change but would benefit in buffering modes and called once per row change.