>I know that there is a SET REPORTBEHAVIOR, but is there also a Behavior setting to counter the changes from VFP 6.0 SQL type code to VFP 8 and 9? I don't want to have to re-write my code.

There's SET ENGINEBEHAVIOR but it goes back to 70 (VFP7) only. Also there're some changes in VFP SQL Engine after VFP6 that are not controlled by SET ENGINEBEHAVIOR because they are considered bug fixes.