To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=68572
Issue #|68572
Summary|Exception on emply select
Component|Spreadsheet
Version|OOo 2.0.3
Platform|PC
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|programming
Assigned to|spreadsheet
Reported by|drjond
------- Additional comments from [EMAIL PROTECTED] Sun Aug 13 12:43:32 -0700
2006 -------
When executing the following section of a BASIC macro, I now get an error that I
didn't get in previous versions of OOo:
...
For iRank = 1 to iRanknum
oDBResult2 = ODBStatement2.executeQuery ("SELECT `DateEarned` FROM
`Members-Ranks` WHERE (lnkUniqueID = '" + sIDNum + "'
AND Status = 'Complete' AND lnkRank = " + iRank + ")")
if (oDBResult2.getString(1) <> "") then
...
where sIDNum has been set outside the loop. This runs fine so long as the query
returns a value (ie there is a record marked 'Complete' for that lnkRank and
that lnkUniqueID value), but if it is a null result then I get the following
error in a dialog box:
BASIC runtime error.
An exception occurred
Type: com.sun.star.lang.DisposedException
Message:.
This same macro has run fine in various versions of OOo including 1.1.x and
2.0.2. If I go into Base and run the query it seems to work (no error
generated).
Let me know if you need further information or clarification on the problem.
Jon
---------------------------------------------------------------------
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]
