long string

[Takumi_(Guest)]

Hello,__I^m using ARPEGGIO version 2.0 report designer.____I designed a report with SQL statement as follows.__ select emp_no, remarks from emp;____This table is defined on oracle 9.2.0 as follows.__ create table emp (__ emp_no char(8),__ remarks varchar2(2000)__ );____When I print this report, remarks field turns into garbage.__If I modify SQL as follows, no garbled.__ select emp_no, substr(remarks, 1, 80) from emp;____But if I change length of substr to 81, garbled again.____Q1. Has this problem been resolved in the latest version of R&R?__Q2. Can I resolve this program in the my ARPEGGIO?____Thank you,__

[kfleming]

Are you using the Oracle8 driver from Oracle?__If so trying an alternate driver (such as the DataDirect driver that ships with Version 10+) should correct things.____Kathleen__R&R Support