On 07/16/2012 02:58 PM, Regina Henschel wrote:
Hi Tom,
Tom Davies schrieb:
Hi :) I am pretty sure that Date is an Sql data-type, just like
double or text but perhaps it got tweaked-off somewhere in the
embedded HsqlDb?
This is not about HSQL but about Basic.
Andrew is almost never wrong and Regina is never wrong so i'm at a
loss about this atm.
There are lot of areas, where I likely wrong. And in Basic I'm sure no
expert.
I have looked a little bit into the code. It seems, that a Basic type
'date' is the same as com::sun::star::bridge::oleautomation struct Date.
But I do not find, where the conversion to string happens.
Kind regards
Regina
I know that I can use a SQL Date type, but the regular Date type behaves
like a double in every case that I have tested.... Note that I cannot
say that I have tested some of the odd cases such as setting the date a
day or two before some big jump based on date changes in history. I have
special routines to convert between the SQL struct. I just did not
expect a Basic Intrinsic Date to convert to a string. I expected it
would auto-convert to Double on return.
If the Basic internals is using a struct rather than a Double as I
thought, then it makes much more sense that it would convert to a string.
I think that I need to document the behavior.
--
Andrew Pitonyak
My Macro Document: http://www.pitonyak.org/AndrewMacro.odt
Info: http://www.pitonyak.org/oo.php
--
For unsubscribe instructions e-mail to: users+h...@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