Hi Ronald,
>Set Reprocess To
This really depends on how you handle locking. If you don't lock record explicitly, AUTOMATIC is probably a good setting. If you use RLOCK(), any of the settings for retrying a certain amount of time or attempts is good. In most projects we use a dedicated lock functions that tries several times and keeps the user informed when locking is impossible.
>Set Tablevalidate To
I had too many problems with this validation and mostly turn it off. If I need to check the record count, I'd limit the check to opening the table, not for every INSERT operation.
--
Christof