>Hello all,
>
>Were any issues addressed in VFP8 related to using Oracle's VARCHAR2 fields in remote views or updateable cursors?
>
>Thanks,
>Bo Durban
YES! In the CursorAdaptor, you have a ConversionFunc property that lets you specify what to do with certain fields in the cursor with respect to what value to post back to the server. For example, populating this property with something like:
LastName TRIM, FirstName TRIM
those values will be trimmed before sent to the server. This is only used for automatic updates where the SQL is generated for you by VFP. You can also choose to develop your own SQL for Insert, Update and/or Deletes. There are properties to store these values in as well - InsertCmd, UpdateCmd and DeleteCmd.
Mark McCasland
Midlothian, TX USA