To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72146
User sarotti changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |FIXED
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Dec 4 13:15:22 -0800
2006 -------
Sorry, I checked everything (also I changed to 2.1 RC2) and now the error is
not reproducible. I made some tests, and maybe it is a (or my) mistake in
declaration the variables. I made the experience that SQL Macro Code with a
date (DIM xxx as Date) is criticel to use when you create a query.
But when you use a date-string it´s easier. I wrote a small function to convert
a date in the standard SQL string (using the command CDateToIso) and now it´s
working fine.
function function_Date_Convert(date_basis as string)
'// this function converts a date in a usable SQL date
Dateconv=CDateToIso(date_basis)
sYear=left(Dateconv, 4)
sDay=right(Dateconv, 2)
sMonth=mid(Dateconv,5,2)
function_Date_Convert=sYear + "-" + sMonth + "-" + sDay
end function
Using this the date format is independent on the language code and it´s easier
to handle. Now it´s possible to use it like this:
....
sDate="01.01.2006"
sDate=function_Date_Convert(sDate)
sSQL="SELECT * FROM `table1` WHERE `Datefield` = #" + sDate + "'"
resultSet=executeQuery(sSQL)
.....
So, think it´s solved now
Thank you for your cooperation
sarotti
---------------------------------------------------------------------
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]
