Issue 114905 - ExecuteQuery does not work when called from a Basic macro
Summary: ExecuteQuery does not work when called from a Basic macro
Status: CLOSED NOT_AN_OOO_ISSUE
Alias: None
Product: Base
Classification: Application
Component: MySQL Connector/OOo (show other issues)
Version: OOo 3.2.1
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: dbaneedsconfirm
QA Contact: issues@dba
URL:
Keywords: needmoreinfo, oooqa
Depends on:
Blocks:
 
Reported: 2010-10-03 16:59 UTC by jgsylvester
Modified: 2010-10-05 07:53 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Database Dialysis (45.58 KB, application/vnd.sun.xml.base)
2010-10-03 18:21 UTC, jgsylvester 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jgsylvester 2010-10-03 16:59:38 UTC 
I have a database "Dialysis" built in OOO base 3.2.1 running under Linux Ubuntu
10.04.1. I have a Basic macro "Updatelatest". This macro calls a another macro
"CreateStatement2(). In "createStatement2()", I create a connection to
"com.sun.star.sdb.DatabaseContext". If I perform an executequery(strSQL) from
within macro "CreateStatement2(), I receive an error 423: Property or method not
found: next. This only occurs from OOo Basic under Ubuntu Linux. If I run this
macro from Windows Vista, it works as expected.
Comment 1 jgsylvester 2010-10-03 18:21:39 UTC 
Created attachment 71928 [details]
Database Dialysis
Comment 2 r4zoli 2010-10-04 07:48:48 UTC 
You use OOo from OOo site or you use ubuntu version?
Comment 3 jgsylvester 2010-10-04 13:51:21 UTC 
I upgraded to OOo 3.2.1 from http://ppa.launchpad.net/openoffice-pkgs/ppa/ubuntu
repository on my Ubuntu 10.04.1. I would be willing to remove my version and
install from OOo site if you think that makes a differeence.
Comment 4 jgsylvester 2010-10-04 17:43:14 UTC 
I am able to reproduce these symptoms with OOo 3.2.1 running under Windows
Vista. I was able to reproduce these symtoms with OOo 3.2.1 running under Ubuntu
10.10 (Maverick) Live CD.
Comment 5 jgsylvester 2010-10-04 23:58:11 UTC 
I made two changes to the macro CreateStatement2(): 1) corrected reference from
"strSQL" to "SQL". (This did not correct the problem), 2) Set a variable
"Result" to the "stmt.executeQuery(SQL)", and referenced "Result.next()". This
last action corrected the problem. I have marked the issue "invalid". Sorry for
bringing up this issue.
Comment 6 r4zoli 2010-10-05 07:53:02 UTC 
Invalid -> closing.