A problem I have been struggling with when using remote views to Oracle is that the field sizes in the VFP view does not match the field sizes in Oracle. For example, in Oracle a table has addr1 with a size of varchar2(40) and addr2 with varchar2(40). In vfp, these show as char(20). I thought the problem might be with the varchar type. But, even after changing the type to char(40) in oracle I still have the same problem. I've deleted and recreated the view several times.
This is causing oracle to give OCI errors when replacing these fields with .null.
Short of hacking the dbc, does anyone know of a reliable way to get fields in VFP remote views to have the correct fields sizes?