Home End User
New Blog Posts: Merging Reports - Part 1 and Part 2

Report Name Lengths - error report

edited December 2002 in End User
When using Oracle 8.1.7 if I try to save a report with a name longer
than the length of the ITEM_NAME field in the database (typically 60
chars), I get a "Operation not applicable" exception, the report will
not be saved, and the report remains open. If I then close the report,
it will not prompt me to save the report - thus losing any changes that
had been made.

The behaviour is a bit different under Paradox. With Paradox the report
name will be truncated to 60 characters and saved. Thus, if you create a
report with a 60 character name, followed by a report with a 61
character name, where the first 60 characters are identical to the first
report, then the second report will simply overwrite the first report.

Probably the simplest way of handling this is to simply set the
MaxLength property of the 'Name' TEdit in the Save dialog to match the
length of the field in the database.

Thanks,

Ed Vander Hoek

Comments

This discussion has been closed.