Hi, I have an stored proc that returns two datasets.
I'm using an UniStoredProc and when it is connected to a MS SQL database works fine, but when it is connected to a MySQL database the second dataset seems to be empty, but calling the sp from a query browser returns the both dastasets correctly.
The UnistoredProc has the fetchAll option set to false.
Code:
UniStoredProc.Open;
ShowMessage(Inttostr(UniStoredProc.RecordCount));
// Return 3
while UniStoredProc.OpenNext do
ShowMessage(Inttostr(UniStoredProc.RecordCount));
// Return 0 !!!
Objects in DB:
/*******************************************************************************
* Selected metadata objects
* -------------------------
* Extracted at 29/07/2009 10:57:12
******************************************************************************/
/*******************************************************************************
* Tables
* ------
* Extracted at 29/07/2009 10:57:12
******************************************************************************/
CREATE TABLE test (
ID Integer NOT NULL AUTO_INCREMENT,
FULL_NAME VarChar(60) NOT NULL,
PRIMARY KEY (
ID
)
) ENGINE=InnoDB;
/*
test
----
Exporting all rows
*/
INSERT INTO test (ID, FULL_NAME) VALUES (1, 'Juan');
INSERT INTO test (ID, FULL_NAME) VALUES (2, 'Pedro');
INSERT INTO test (ID, FULL_NAME) VALUES (3, 'Raul');
INSERT INTO test (ID, FULL_NAME) VALUES (4, 'Jose');
INSERT INTO test (ID, FULL_NAME) VALUES (5, 'Ramon');
INSERT INTO test (ID, FULL_NAME) VALUES (6, 'Carlos');
/* 6 row(s) exported */
/*******************************************************************************
* Stored Procedures
* -----------------
* Extracted at 29/07/2009 10:57:12
******************************************************************************/
CREATE PROCEDURE MultiDataset()
begin
select *
from test
order by full_name
limit 3;
select *
from test
order by id
limit 3;
end
/
OpenNext returns no records
Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Return to “Universal Data Access Components”
Jump to
- General Forums
- ↳ Announcements
- Database Tools
- ↳ dbForge for MySQL
- ↳ dbForge for Oracle
- ↳ dbForge for PostgreSQL
- ↳ dbForge for SQL Server
- ADO.NET Data Providers
- ↳ Entity Framework support
- ↳ LinqConnect (LINQ to SQL support)
- ↳ dotConnect for Oracle
- ↳ dotConnect for MySQL
- ↳ dotConnect for PostgreSQL
- ↳ dotConnect for SQLite
- ↳ dotConnect for DB2
- ↳ dotConnect for SQL Server
- ↳ dotConnect for Cloud Applications
- ↳ dotConnect Universal
- ↳ Entity Developer
- Delphi Data Access Components
- ↳ EntityDAC
- ↳ Universal Data Access Components
- ↳ Oracle Data Access Components
- ↳ SQL Server Data Access Components
- ↳ MySQL Data Access Components
- ↳ InterBase Data Access Components
- ↳ PostgreSQL Data Access Components
- ↳ SQLite Data Access Components
- ↳ VirtualDAC
- dbExpress Drivers
- ↳ dbExpress driver for Oracle
- ↳ dbExpress driver for SQL Server
- ↳ dbExpress driver for MySQL
- ↳ dbExpress driver for InterBase & Firebird
- ↳ dbExpress driver for PostgreSQL
- ↳ dbExpress driver for SQLite
- ODBC Drivers
- ↳ ODBC Drivers
- Network Security
- ↳ SecureBridge
- Developer Tools
- ↳ Code Compare
- ↳ Review Assistant
- ↳ LINQ Insight
- ↳ SSIS Data Flow Components
- ↳ Excel Add-ins