Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
CursorFill Does not support Oracle LONG RAW and GENERAL
Message
From
18/04/2005 08:07:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
CursorFill Does not support Oracle LONG RAW and GENERAL
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows 2000 Server
Database:
Oracle
Miscellaneous
Thread ID:
01005736
Message ID:
01005736
Views:
69
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
Next
Reply
Map
View

Click here to load this message in the networking platform