To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=66283
Issue #:|66283
Summary:|wrong sql commands sended to mysql by oobase
Component:|Database access
Version:|OOo 2.0.2
Platform:|All
URL:|
OS/Version:|Linux
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|none
Assigned to:|dbaneedsconfirm
Reported by:|lmichnovic
------- Additional comments from [EMAIL PROTECTED] Fri Jun 9 07:39:46 -0700
2006 -------
I've connected to mysql database 5.0 using ODBC driver. I have created few
tables in oobase and I have edited them using oobase. After writeing one line,
oobase shows error message about wrong sql command. Mysql log shows command
060609 14:33:48 1 Query INSERT INTO `test`.`Tabu` ( `ID`, `meno`,
`pocet_deti` ) VALUES ( 5, 'Ignac', 3 )
1 Query SELECT LAST_INSERT_ID()
1 Query SELECT * FROM `test`.`Tabu` WHERE
`Tabu`.`ID` = 5,00000000000000000e+00
The ID is integer, but it was used in the command as float.
Actualy the data are written into the mysql database. But oobase don't think it
is so and after anything I do in oobase it shows another error message about
duplicate od ID, because oobase send the previous insert command again and
again. But the error is IMHO in ID that is sended as float and not as integer.
---------------------------------------------------------------------
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]
