Greetings,
I am sorry, I wasn't specific enough. The part about date formats was
for background information to the real problem. My focus should have
been on the Base error reporting, not the date formats. I am adjusting
to using slashes instead of dashes. That isn't a big problem for me.
The point I was trying to make was that when I forget and use dashes,
this particular error message was not very informative and I, for one,
would like to see more diagnostic information in the Java exception
error dialog so I could determine what the problem is. Since posting
this message, I have given it some thought and now believe the problem
may not be with Base so much as with Java not reporting more
information. Not knowing the inner workings of both Base and Java, not
to mention the Connector/driver, I cannot tell where the error message
problem may be.
Thanks for the response.
Girvin Herr
rost52 wrote:
In Calc I always enter in format yy/mm/dd and it appears in the format
of the cell, so far for every format I have d used. In the Calc cells
I never use yy/mm/dd format.
On 2012-12-30 9:46, Dan Lewis wrote:
On 12/29/2012 03:28 PM, Girvin R. Herr wrote:
Greetings,
I noted that after I updated LO from 3.5.7 to 3.6.4, the Base date
entry format flexibility has changed. With a 3.5.7 (and before)
Base form, I could enter 12-29-12 and it would be changed to
12/29/12. With 3.6.4, entering 12-29-12 will result in a strange
date, as if it were interpreting the dashes as a formula and maybe
subtracting the numbers. Okay, I could live with that because it
was apparent that the date was incorrect. But now I see this is
resulting in a Java error when I accidentally use dashes and try to
save the record. I get "Java.lang.IllegalArgumentException"
errors. Even that could be worked around, if the error message had
any diagnostics, such as the offending date. However, this is all I
get. No SQL. No indication as to what the problem really is. I
got a clue by doing a web search and found a similar error with
dates and put two-and-two together to determine the real cause. I
guess my complaint is that between 3.5 and 3.6, the error messages
stopped putting diagnostic data into the message. Has anyone else
seen this "feature"?
Is there an option somewhere to add the diagnostics to error messages?
Note that I tried entering 12-29-12 into a Calc date cell where the
format was "MM/DD/YY" and it kept the dashes.
Girvin Herr
If you are going to use a date format with hyphens, perhaps
learning to use this format: YYYY-MM-DD. This is recognized by both
Base and Calc. (Probably by most databases and spreadsheets.
--Dan
--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.