Zeoslib Portal

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

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

procedure TZAbstractRODataset.RefreshParams; var DataSet: TDataSet; begin DisableControls; try if FDataLink.DataSource <> nil then begin DataSet := FDataLink.DataSource.DataSet; if DataSet <> nil then if DataSet.Active and not (DataSet.State in [dsSetKey, dsEdit, dsInsert]) then begin //VISOR Close;...

Tnx

Please write SVN ZeosDBO 6.6.x

Hi.

Thank. It it work.

Regards.

In previor 6.5 version sorting in dataset (class TZAbstractRODataset) work absolutately correct. In version 6.6 bangfauzan modifation have broken sorting. Where sort asc or desc in 1 field, method do not work. Example Sord ID asc, Name desc this method do not work correct. method InternalSort if FIn...

What for so to use BLOB-field ???
temp := form1.Link_Query.FieldByName('dok')).asstring;

I resolved. I use path [ 1220418 ] !Quick and durty! patch for 5.x stored procedures http://sourceforge.net/tracker/index.php?func=detail&aid=1220418&group_id=35994&atid=415826 I implement link to function mysql_next_result. http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries....

It is example: CREATE PROCEDURE `dorepeat`(p1 INTEGER(11)) BEGIN select @x:=0; -- without this line work in any situation set @x=0; REPEAT SET @x = @x + 1; UNTIL @x > p1 END REPEAT; END call dorepeat(100000); -- work select (@x) call dorepeat(1000000); --don't work select (@x) The correct sintaxis ...

up

zippo wrote:Try to use ".Open" instead of ".Exec".

Call proced() ZQuery.Open ??? why?

Use libmysql.dll from that version mysql 5, in which work.

Whether will be realized RefreshRow in TZDataset ?

Why do not add ïîääåðêó MySQL 5.x in the version ZeosDBO 6.5 ?

Certainly and even so:)

-----
case CurrentType of
stInteger,stShort,stLong,stByte://VISOR
----


Because other types too are not converted KeyValues .VString