General information
Category:
Coding, syntax & commands
Title:
CursorFill Does not support Oracle LONG RAW and GENERAL
Environment versions
Network:
Windows 2000 Server
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
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