I ran into problems with numeric overflows when there was no numeric overflow, using INSERT - SQL and had to revert to APPEND and REPLACE in certain cases. I suspect this was because of the memo field issue.
To move a mountain start with the smallest stone