Anybody use Base?

Alex · 01-24-2010, 05:43 PM

Anybody here familiar with Base, the database component of Open Office?

I had a small task that I thought I'd try doing in a database rather than my standard practice of just bruting it in Excel. So I tried setting it up in Base since I have that and have never played with it.

For some reason, a date field I have automatically changes to 1/1/1800 any date I enter that is prior to that. So 6/5/1756 becomes 1/1/1800.

But only when doing data entry through a form. When I do it directly in a table it is saved correctly (though still appears as 1/1/1800 in the form view).

Anybody use and have thoughts? I can find zero help on this online so I'm sure it is something really stupid I'm doing.

JWBear · 01-24-2010, 09:19 PM

"All your Base belong to us."

(Well... Someone had to say it!)

Ghoulish Delight · 01-24-2010, 10:02 PM

I found one message board in French that made reference to Base and 1/1/1800. Based on the Google translation, I don't think it's the same issue, but it wasn't quite clear. The only suggestion I could make out from it that might was to change the date format to yyyy-mm-dd before going to form view. Again, I don't think it's the same thing as the OP was talking about an error message "value 0000-00-00 cannot be represented as java.sql.Date" and you don't seem to be seeing that error.

ETA: Hmm, further reading on that board seems to indicate that "1/1/1800" might mean it thinks it's looking at a value of "null" for a date. The 0000-00-00 and error message seem specific to converting from sql to base, but the "solution" seems to be to tell base to read "0000-00-00" (and otherwise invalid date value in base) as a NULL, which it then displays as 1/1/1800. No idea if any of that helps your situation though.

Here's the link I'm gleaning this from.
http://translate.google.com/translat...L_enUS347US348

Ghoulish Delight · 01-24-2010, 10:08 PM

Oh hey, you gave an example date of 1756. Was that just an example, or are the dates you're working with all before 1800? Because it seems that JDBC represents dates as offsets from 1/1/1800.

Alex · 01-24-2010, 10:21 PM

It is only dates from before 1/1/1800 that get converted.

But surely there must be some way to do a database of things older than that. And I can't find anything that even mentions these dates being changed.

Ghoulish Delight · 01-24-2010, 10:38 PM

Aha. Set the field type to "date" in the table, instead of numeric with date formatting.

source

Tref · 01-24-2010, 10:40 PM

I'm more of a mineral face powder man myself.

RStar · 01-24-2010, 11:35 PM

Oh. You don't mean free base.

Then no, I have not used it.

Alex · 01-24-2010, 11:48 PM

Quote:

Originally Posted by Ghoulish Delight

Aha. Set the field type to "date" in the table, instead of numeric with date formatting.

source

Thank you! That was completely not the problem!

But it did point me to a settings menu I had not found (Open Office help sucks) and I did find a setting in there that was causing the problem. Why the default for a date form field would not be to just accept any date I have no idea.

Thanks very much for looking into it. Your searching was better than mine.

Ghoulish Delight · 01-25-2010, 12:00 AM

Quote:

Originally Posted by Alex

Thank you! That was completely not the problem!

Always glad to help

Quote:

Thanks very much for looking into it. Your searching was better than mine.

"open office" form date 1800

01-24-2010, 05:43 PM	#1
Alex . Join Date: Feb 2005 Posts: 13,354	Anybody use Base? Anybody here familiar with Base, the database component of Open Office? I had a small task that I thought I'd try doing in a database rather than my standard practice of just bruting it in Excel. So I tried setting it up in Base since I have that and have never played with it. For some reason, a date field I have automatically changes to 1/1/1800 any date I enter that is prior to that. So 6/5/1756 becomes 1/1/1800. But only when doing data entry through a form. When I do it directly in a table it is saved correctly (though still appears as 1/1/1800 in the form view). Anybody use and have thoughts? I can find zero help on this online so I'm sure it is something really stupid I'm doing.
	Submit to Quotes

01-24-2010, 09:19 PM	#2
JWBear Worn Romantic Join Date: Feb 2006 Location: Long Beach California Posts: 8,435	"All your Base belong to us." (Well... Someone had to say it!) __________________ Unrestrained frivolity will lead to the downfall of modern society.
	Submit to Quotes

01-24-2010, 10:02 PM	#3
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	I found one message board in French that made reference to Base and 1/1/1800. Based on the Google translation, I don't think it's the same issue, but it wasn't quite clear. The only suggestion I could make out from it that might was to change the date format to yyyy-mm-dd before going to form view. Again, I don't think it's the same thing as the OP was talking about an error message "value 0000-00-00 cannot be represented as java.sql.Date" and you don't seem to be seeing that error. ETA: Hmm, further reading on that board seems to indicate that "1/1/1800" might mean it thinks it's looking at a value of "null" for a date. The 0000-00-00 and error message seem specific to converting from sql to base, but the "solution" seems to be to tell base to read "0000-00-00" (and otherwise invalid date value in base) as a NULL, which it then displays as 1/1/1800. No idea if any of that helps your situation though. Here's the link I'm gleaning this from. http://translate.google.com/translat...L_enUS347US348 __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes

01-24-2010, 10:08 PM	#4
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	Oh hey, you gave an example date of 1756. Was that just an example, or are the dates you're working with all before 1800? Because it seems that JDBC represents dates as offsets from 1/1/1800. __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes

01-24-2010, 10:21 PM	#5
Alex . Join Date: Feb 2005 Posts: 13,354	It is only dates from before 1/1/1800 that get converted. But surely there must be some way to do a database of things older than that. And I can't find anything that even mentions these dates being changed.
	Submit to Quotes

01-24-2010, 10:38 PM	#6
Ghoulish Delight I Floop the Pig Join Date: Jan 2005 Location: Alternative Swankstyle Posts: 19,348	Aha. Set the field type to "date" in the table, instead of numeric with date formatting. source __________________ 'He who receives an idea from me, receives instruction himself without lessening mine; as he who lights his taper at mine, receives light without darkening me.' -TJ
	Submit to Quotes

01-24-2010, 10:40 PM	#7
Tref Not Tref Join Date: Jan 2005 Posts: 2,188	I'm more of a mineral face powder man myself. __________________ Tref3.0 Listen in aural 3-D to Pop's muzak! (New songs added semi-bi-daily) j & j Did you know that Emas eht yltcaxe is exactly the same spelled backwards?!
	Submit to Quotes

01-24-2010, 11:35 PM	#8
RStar Senior Member Join Date: Jun 2006 Location: Me & Manyard hangin out! Posts: 5,433	Oh. You don't mean free base. Then no, I have not used it. __________________ Meddle not in the affairs of Dragons, for you are crunchy and good with ketchup! www.StarTownGifts.com
	Submit to Quotes