>> Were any issues addressed in VFP8 related to using Oracle's VARCHAR2 fields in remote views or updateable cursors?
> Be more specific, I made 3 VFP_Oracle projects
> I try to avoid views, but in sqlexec this type work well
The biggest problem is updatable cursors (or remote views) will pad your VARCHAR2 fields with spaces when an UPDATE or INSERT is done. I know you can get around this (most of the time) by using the SQLEXEC command, but you throw away a lot of very nice built-in functionality by only using SQLEXEC.
It sounds like the new CursorAdapter class is very powerful but it also sounds like it makes use of updateable cursor technology. I was just hoping that issues with VARCHARs were addressed or it may not be usable with Oracle and VARCHAR2.
Here is a KB of another related issue:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q170129Thanks,
Bo Durban
