Bug 37720 - Error by RowSet.execute()
Summary: Error by RowSet.execute()
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: BASIC (show other bugs)
Version:
(earliest affected)
3.4.0 release
Hardware: x86-64 (AMD64) Windows (All)
: low trivial
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-05-29 08:34 UTC by Ishayahu
Modified: 2012-10-14 13:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Example (29.75 KB, application/vnd.sun.xml.base)
2011-05-29 08:34 UTC, Ishayahu
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Ishayahu 2011-05-29 08:34:27 UTC
Created attachment 47278 [details]
Example

I was used this code:

DatabaseContext = createUnoService ("com.sun.star.sdb.DatabaseContext")
ITBase = DatabaseContext.getByName ("IT")
QueryP="SELECT КодАктива, Модель FROM Активы WHERE КодКатегорииАктива = 0 AND КодСтатуса= 0"
RowSet = createUnoService("com.sun.star.sdb.RowSet")
RowSet.DataSourceName = "IT"
RowSet.Command = QueryP
RowSet.execute()

But when it comes to "RowSet.execute()" - I get an Error without description. I was checked this in LibO 3.3 - all works correctly

This macro is in module "lib" - sub "SelectSuitableCartrige"
Comment 1 Rainer Bielefeld Retired 2011-06-10 02:57:31 UTC
RC2 is bit by bit identical with release version, so separate items in the version picker are useless. Changes have been discussed with Michael Meeks.
Comment 2 Björn Michaelsen 2011-12-23 12:05:30 UTC
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:
http://wiki.documentfoundation.org/QA/BugHunting_Session_3.5.0.-1

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 3 Florian Reisinger 2012-08-14 14:03:28 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 4 Florian Reisinger 2012-08-14 14:04:23 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 5 Florian Reisinger 2012-08-14 14:08:54 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 6 Florian Reisinger 2012-08-14 14:10:55 UTC
Dear bug submitter!

Due to the fact, that there are a lot of NEEDINFO bugs with no answer within the last six months, we close all of these bugs.

To keep this message short, more infos are available @ https://wiki.documentfoundation.org/QA/NeedinfoClosure#Statement

Thanks for understanding and hopefully updating your bug, so that everything is prepared for developers to fix your problem.

Yours!

Florian
Comment 7 sasha.libreoffice 2012-09-07 06:14:06 UTC
Not tested yet. Reopening
Comment 8 Terrence Enger 2012-10-10 13:28:03 UTC
On Linux with a recent build from master the message box says ...

    BASIC runtime error.
    An exception occurred 
    Type: com.sun.star.sdbc.SQLException
    Message: Syntax error in SQL expression.

(This is a true message, as far as I can see, as the SELECT statement
ends with an extra, "ASC".)


I am leaving the bug status unchanged because of my different
enviroment.  However, if someone in the reporter's environment can
verify his result, then I suggest that we change bug summary to
complain about the blank message and start over with the bug process.
I think that the first step of that process would be to verify that
the problem still exists in newer versions of LibreOffice.
Comment 9 sasha.libreoffice 2012-10-11 09:35:34 UTC
No problem described in original description in 3.6.2 on Windows XP 32 bit
IMHO status should be WFM
Comment 10 Terrence Enger 2012-10-14 13:25:11 UTC
Several days without comment, and nothing from Ishayahu since the
original report.  Setting WFM.