Report Name Lengths - error report
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
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
This discussion has been closed.
Comments
edit box appropriately.
Thankyou for the suggestion- I'll add it to the maintenance list!
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com