MySQL5 - Stored procedures

[bravecobra]

Is there a way of "converting" that IZResultset to a TDataset on zdbc level? Basically that's what TZAbstractRODataset does, not?

In ZDbcMySQLStatement I found that

Code: Select all

TZMySQLStatement.ExecuteQuery
....
Result := CreateResultSet(SQL); //Yeah, ok but the last one plz!! ;)

Can we have some code here that loops it till the end (if wanted). I tried adding the repeat unitl loop here but that breaks the normal working of TZQuery and related components.

[Visor123]

The mysql error after open in query CALL ProcedureName();

CR_COMMANDS_OUT_OF_SYNC

method GetMoreResults not work with CALL (((
Version 6.6.2
SVN rev. 267

[v-maguryan]

The BUG in source code ZEOS library in unit ZDbcMySqlResultSet.

Try to change this source code and then try to test STORED PROCEDURES:

Code: Select all

procedure TZMySQLResultSet.Close; 
begin 
  if FQueryHandle <> nil then begin 
    FPlainDriver.FreeResult(FQueryHandle); 
    while FPlainDriver.RetrieveNextRowset( FHandle) = 0 do begin 
      FQueryHandle := FPlainDriver.StoreResult(FHandle); 
      if Assigned(FQueryHandle) then 
        FPlainDriver.FreeResult(FQueryHandle); 
    end; 
  end; 
  FQueryHandle := nil; 
  FRowHandle := nil; 
  inherited Close; 
end;