Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement