Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote connections with VARCHAR2 data types
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00710166
Message ID:
00711264
Views:
11
>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform