To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=87972
User er changed the following:
What |Old value |New value
================================================================================
CC|'' |'er'
--------------------------------------------------------------------------------
Assigned to|er |oj
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Sep 10 14:17:17 +0000
2008 -------
@oj: sigh.. that seems to be another case of where the database driver attempts
to be smarter than dBase.. the problem here is the field description
BILL_NO,N,4,0 in D1 that is numeric 4 digits with no decimals. If that's changed
to BILL_NO,N,5,0 the file can be saved. Note that the numeric data in column D
does not exceed 3 integer digits.
To account for the internal odbc representation that adds to the length, a call
to
nFieldLen = SvDbaseConverter::ConvertPrecisionToOdbc( nFieldLen, nPrecision );
where nFieldLen=4, nPrecision=0 results in nFieldLen=3; therefor the values set
at the column descriptor are 3 for precision and 0 for scale. Note that in a
non-pro build the assertion
Error: getDataSourceSetting: caught an exception!
>From File /so/ws/DEV300/src/dbaccess/source/core/misc/sdbcoretools.cxx at Line
>127
is displayed twice during the call to sdbc::XRowSet::execute(), didn't
investigate whether that's related, probably yes; the same assertion is
displayed when loading the document. Then when writing the values with
sdbc::XResultSetUpdate::insertRow() the error is reported. The exception thrown
is
SQLException ErrorCode: 0, SQLState: HY000, Message: invalid value for column
'BILL_NO'
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
