jhunt1111
asked on
Tuncated memo field in ADO recordset
Good Morning,
I am pulling records from a table in an Oracle database where the last field being pulled is a memo field. The field is simply being truncated around 2057 characters. I thought at first it was a limitation to my variable I was placing the text from the memo field into however my code goes on to continue to append text over 2100 charcters to the varable in code. So I am pretty sure it is getting truncated in the recordset.
Here is an example of what I am attempting to do:
Dim rstPublicViews As New ADODB.Recordset
Dim strsql as String
Dim vrtText as Variant <-- I have tried String also
OpenDBConnections <-- this functions opens my database connections setting the public connection object conn1
strsql = "SELECT OWNER, VIEW_NAME, TEXT FROM ALL_VIEWS WHERE VIEW_NAME='PVSIGNOFF'"
rstPublicViews.Open strsql, conn1, adOpenKeyset, adLockReadOnly
vrtText = rstPublicViews("TEXT") <-- I have also tried vrtText = rstPublicViews("TEXT").Val ue
The vrText is truncated When I do a Len(vrtText) /or/ Len(rstPublicViews("TEXT") ) the value is always: 2054
The DefinedSize Property returns: 2147483647
The ActualSize Property retuens: 2054
I have tried various methods using GetChunk with the same results... I am beating my head against the desk this morning. Any help would greatly apperciated.
Thanks in advance for your time & help,
Jeff
I am pulling records from a table in an Oracle database where the last field being pulled is a memo field. The field is simply being truncated around 2057 characters. I thought at first it was a limitation to my variable I was placing the text from the memo field into however my code goes on to continue to append text over 2100 charcters to the varable in code. So I am pretty sure it is getting truncated in the recordset.
Here is an example of what I am attempting to do:
Dim rstPublicViews As New ADODB.Recordset
Dim strsql as String
Dim vrtText as Variant <-- I have tried String also
OpenDBConnections <-- this functions opens my database connections setting the public connection object conn1
strsql = "SELECT OWNER, VIEW_NAME, TEXT FROM ALL_VIEWS WHERE VIEW_NAME='PVSIGNOFF'"
rstPublicViews.Open strsql, conn1, adOpenKeyset, adLockReadOnly
vrtText = rstPublicViews("TEXT") <-- I have also tried vrtText = rstPublicViews("TEXT").Val
The vrText is truncated When I do a Len(vrtText) /or/ Len(rstPublicViews("TEXT")
The DefinedSize Property returns: 2147483647
The ActualSize Property retuens: 2054
I have tried various methods using GetChunk with the same results... I am beating my head against the desk this morning. Any help would greatly apperciated.
Thanks in advance for your time & help,
Jeff
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
TMacT,
Thank you for suggestion, I downloaded another driver ... version 9.00.01.08 ... not sure why but it works! thanks for the input
I will accept your reply.
Thanks again!!
Jeff
Thank you for suggestion, I downloaded another driver ... version 9.00.01.08 ... not sure why but it works! thanks for the input
I will accept your reply.
Thanks again!!
Jeff
ASKER
Oracle in 9iR1CLl version: 9.00.11.00
I will attempt to look for a different driver and give that a try.
I will update post on wheter it works or not :)
Thanks,
Jeff