>>>>By the way, can you use a VFP cursor result to upload data or it will only work with tables?
>>>
>>>Yes, inserting data from a VFP cursor works the same. If you are going to use the APPEND FROM most likely you need to create a cursor in order to create the same structure as your Oracle table. The code is a bare bones solution to get you started. Once you have your Oracle cursor updatable you can add data to it as if it were a buffered VFP table.
>>>
>>>>I remember the VFP to Oracle wizard (VFP5) used to transfer memo field to Long. How do you handle a table that has more than 1 memo column?
>>>
>>>It depends on what version of Oracle you are working with? In the old days Oracle only allowed (and still does) one LONG data type column per table. I think as of Oracle 9i there is a CLOB data type. You can have any number of CLOB data types in an Oracle table. Oracle now advises the use of the CLOB data type over the LONG.
>>>
>>>FYI, you must use the Oracle ODBC driver with CLOB data types. MS Oracle ODBC driver does not work with CLOB data types.
>>>
>>>>Thanks Will
>>>
>>>You're welcome. At first, getting the CURSORSETPROP settings right can be tricky. Let me know if you any problems.
>>
>>Will
>>
>>So far, not succeeding. I am using MS Oracle ODBC. I can not find the Oracle ODBC driver for the XE (free one) do you ever used the XE edition if so, do you know where I can find a ODBC driver for it.
>>
>> Do you have a simple example for CURSORSETPROP?
>>
>>Thanks
>>Mo
>
>
http://www.oracle.com/technology/software/tech/windows/odbc/index.html>
>
>llReturn=llReturn AND CURSORSETPROP( 'Tables','document', 'insert_table' )
>llReturn=llReturn AND CURSORSETPROP( 'KeyFieldList', 'id','insert_table' )
>llReturn=llReturn AND CURSORSETPROP( 'UpdatableFieldList','id,filename,contents', 'insert_table' )
>llReturn=llReturn AND CURSORSETPROP( 'UpdateNameList','id document.id,filename document.filename,contents document.contents', 'insert_table' )
>
>llReturn=llReturn AND CURSORSETPROP( 'WhereType', 1, 'insert_table' )
>llReturn=llReturn AND CURSORSETPROP( 'Buffering', 5, 'insert_table' )
>llReturn=llReturn AND CURSORSETPROP( 'SendUpdates',.T., 'insert_table' )
>
I got it working on a simple table.
As for the driver, I got the Oracle ODBC but installing it required the presence of Installer which does not come with Oracle XE.
For me, that was a proof of concept. I let you know if I need more help. Thanks again.