Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Oracle Reports to report on MS-Access data (memo field)

Status
Not open for further replies.
peerytek

peerytek

Programmer
Oct 24, 2000
1
US
When accessing a memo field from MS-Access the return datatype is Long. The report does not show any data. I tried "LTRIM(RTRIM(fieldname))" -- data type returned was a char (255) everything after the 255 byte was truncated.

Any answers?
 
Status
Not open for further replies.

Similar threads

blobby36
  • Locked
  • Question
crystal reports command and oracle tables
Replies
1
Views
404
oradba101
oradba101
soushi01
  • Locked
  • Question
Oracle reports bulider cannot use CASE WHEN statement 1
Replies
4
Views
519
soushi01
soushi01
OrangeMonkey
  • Locked
  • Question
Reports Builder Novice
Replies
0
Views
359
OrangeMonkey
OrangeMonkey
c29537
  • Locked
  • Question
SSRS Oracle Connection
Replies
0
Views
250
c29537
c29537
thatgirl100
  • Locked
  • Question
Reports 6i - Multiple Pages in Report Header?
Replies
0
Views
509
thatgirl100
thatgirl100

Part and Inventory Search

Sponsor

Back
Top