General information
Category:
Coding, syntax & commands
I implemented the mirroring by creating a record-level validation rule that calls a stored procedure that basically does:
DO CASE
CASE OLDVAL(desc) != desc && if desc has changed, propogate the change
REPLACE cDesc WITH desc
CASE OLDVAL(cDesc) != cDesc && if cdesc has changed, propogate the change
REPLACE cDesc WITH desc
CASE desc != cDesc && if they're different, assume that desc is correct
REPLACE cDesc WITH desc
ENDIF
This works fine in all the testing I've done. But, I've got a VFP 3.0 book that says "validation code cannot change any field in the current record". Maybe the book is wrong. I couldn't find any VFP 5.0 doc saying it was OK or not OK to do this.
Bob
P.S. Thanks for all the help, even if you post at odd hours <g>
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only