To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=90107
Issue #|90107
Summary|Error during update fields
Component|utilities
Version|OOo 2.4.1 RC1
Platform|HP
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|code
Assigned to|mh
Reported by|pbd4499
------- Additional comments from [EMAIL PROTECTED] Thu May 29 11:49:03 +0000
2008 -------
Since we are using OOo 2.4.1 we get an error during the update of a local
database.
Motivation:
- we have 2 kind of systems desktop & notebooks in the software we use a switch
to get database tables, fields information for user settings which is be done
via a wissel 1) OOo_d.odt and 2) OOo_n.odt.
1) is a connection, via ODBC to MySQL and worked properly (indoor desktops);
2) is a connection, via ODBC to ms-Access and is not working properly since
version 2.4.0 (indoor/outdoor notebooks);
All users need to be able to update a 'file'-counter value increment by one
each time they create a new doc from our automated templates. For the group 1)
it works properly with the line for this goup but however when a notebook does
the same with the right code for the notebook it doesn't work any longer and we
get the error: Basic-runtime-error, type: com.sun.star.sdbc.sqlexception,
Message: No Resultset was produced.
The code:
IF blNotebook = FALSE THEN
strSql = "UPDATE tblcounter SET CounterDesk=" & intWsCounter
& " WHERE User_ID =" & intUserID
Statement.executeUpdate(strSql)
Connection.close()
ELSEIF blNotebook = TRUE THEN
MSGBOX intTpCounter & ", intuserid: " & intUserID
strSql = "UPDATE ""tblcounter"" SET ""CounterNote""=" &
intTpCounter & " WHERE User_ID =" & intUserID
ResultSet = Statement.executeQuery(strSql)
END IF
it hangs, on notebooks: 'blNotebook= true', on the line: ResultSet =
Statement.executeQuery(strSql)
Hopefully you can solve this. It worked properly in several previous versions.
Best regards,
Perry
---------------------------------------------------------------------
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]
