>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.
Mark McCasland
Midlothian, TX USA