CONVERSIONFUNCTIONS OF CURSORADAPTER CLASS

[naeempk]

Hi,

I am using oracle database with vfp via ODBC and use SPT commands to send/receive data from vfp. I have to convert VFP date fields with oracle "to_date" function or a vfp logical field to numeric 1/0 before sending my vfp data to oracle.

I want to use CursorAdapter with Oracle database. How can I use "ConversionFunctions /ConversionFunc" property to do the same ? Any code example or tips related to VFP CA with Oracle database ?

TIA
Naeem

 

[Olaf Doschke]

You can't use ORACLE functions there, that would need to be done by autoconversion via ODBC, when you specify a cursor schema for the CA cursor.
And at the stage of updating you can apply VFP function like TRIM to values before they are sent over.

See

https://msdn.microsoft.com/de-de/library/540267c9(v=vs.80).aspx

(If you look at the help on the Auto-Update tab you're directed there in regard of that part of the builder.

So you might address the wrong parameter.
I never used this property and am unsure why it would be readonly, as the help says it's read/write both at design time and run time.

What works seamless for example is retrieve a MSSQL bit type as a VFP logical field and save it as bit value, no conversion function needed for it. So maybe concentrate on the cursor schema on the data access tab.

Bye, Olaf.