To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=72146
Issue #|72146
Summary|date conversion in macro SQL code
Component|api
Version|OOo 2.1
Platform|All
URL|
OS/Version|Windows 98
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P2
Subcomponent|code
Assigned to|jsc
Reported by|sarotti
------- Additional comments from [EMAIL PROTECTED] Thu Nov 30 08:54:24 -0800
2006 -------
Hi,
problem with RC1 of OO 2.1:
there is a problem with a date code in macro programming
example for the SQL-Code:
Select * FROM `table_x` WHERE `date1` ={D '2006-11-29'} AND `date2` = {D '2006-
11-29'} AND ....
This SQL command is working in my MySQL database (as well in the native SQL
Code and also as an OO query). If I use an "executeQuery" command in a macro
code, the date code is converted. Now there are slashes "/" (... `date1` =#2006/
11/29# ....) in the command, as a result there occures a runtime error in basic
(syntax error in query).
Also changing the language settings doesn´t change this....
Thank you for your help
best regards
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]
