Issue 114314

Summary: Base only retreives first result set when MySQL procedure returns multiple result sets
Product: Base Reporter: prune <bdt>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: arielch, issues
Version: OOO320m12   
Target Milestone: ---   
Hardware: Unknown   
OS: Windows Vista   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---

Description prune 2010-09-05 03:09:08 UTC
When I run a query that simply calls a MySQL stored procedure (I'm using ODBC)
which returns multiple result sets, Base only displays the first result set. 
Using DataPilot in Calc to try to use the database as a source likewise only
gets the first result set.
Comment 1 marc.neumann 2010-09-13 12:39:53 UTC
hi, yes this is because base can only handle 1 result set yet. I set this issue
to Feature and send to the right team.
Comment 2 Ariel Constenla-Haile 2012-09-08 21:12:08 UTC
Changing component.
The reporter is using ODBC, not the MySQL Connector/OOo