>>Has anyone came up with a fix for the problem with the VARCHAR2 data types in Oracle. Remote Views in VFP will always pad the field with spaces. I have several tables that have the key field as a VARCHAR2 in Oracle. I can not use remote views to update the Oracle data because '123' and '123 ' don't match! I can use SPT to update the tables and ADO seems to work but I really want to use remote views.
>>
>>-David-
>
>Then you would have to change the view's update type to Key Fields only. This is a known issue with this data type in Oracle. This was discussed in Thread #
245948 dated July 25 in the Client/Server category.
I checked out the thread, thanks. My problem is that the Key Field is a varchar2 data type. The discussion in this thread addressed options where non-key fields were varchar2's.