General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only