Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
CursorFill Does not support Oracle LONG RAW and GENERAL
Message
De
18/04/2005 08:07:30
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
CursorFill Does not support Oracle LONG RAW and GENERAL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Oracle
Divers
Thread ID:
01005736
Message ID:
01005736
Vues:
71
Hi,

If I build a table like this:
create table test (a long raw);

Then when using the code:
....
loCursor = CREATEOBJECT('CURSORADAPTER')
loCursor.Alias=lcCursorName
loCursor.DataSourceType="ADO"
loCursor.DATASOURCE = loRecordSet
loCursor.SELECTCMD = lcSQL
loCursor.DATASOURCE.ACTIVECONNECTION = oConnection
lnOptions=0
?loCursor.CURSORFILL(.F., .F., lnOptions, loCommand)
....

The system returns my LONG RAW field as a memo. Using ODBC it returns a GENERAL field as I need.

If I change the type to BLOB then I get "Microsoft OLE DB Provider for Oracle : Data type is not supported."

Does anyone now how I can handle a General field with a table stored in the oracle database using ADO.

Thanks
Tim
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform