Zeoslib Portal

SELECT @n ::= @n+1 AS rownum, thing, arms, legs FROM limbs

or set checkparam = false in property of component (TZReadOnlyQuery)

I have a very strange problem with the following SQL

SELECT @a as a, @b as b, @c as c, @d as d, @e as e;

If all valiables is null then is generated error: "Range check error".


But following SQL work fine.

SELECT @a as a, @b as b, @c as c, @d as d.



Delphi 7, Mysql 5.0.45

I have some problem with UDF for raise error. In unit ZDbcMySqlUtils in procedure CheckMySQLError replace And with OR [syntax="Delphi"] procedure CheckMySQLError(PlainDriver: IZMySQLPlainDriver; Handle: PZMySQLConnect; LogCategory: TZLoggingCategory; const LogMessage: string); var ErrorMes...

?

Always was without SET but function never call. Old procedure not call FPlaindriver.SetAutocommit [syntax="delphi"] procedure TZMySQLConnection.SetAutoCommit(AutoCommit: Boolean); var SQL: PChar; begin if AutoCommit <> Self.AutoCommit then begin inherited SetAutoCommit(AutoCommit); if not ...

In unit ZPlainMySQLDriver.pas function "TZMySQL40PlainDriver.SetAutocommit" is incorrect [syntax="delphi"] function TZMySQL40PlainDriver.SetAutocommit(Handle: PZMySQLConnect; mode: Boolean): Boolean; var query: AnsiString; testResult: Integer; begin if (mode = True) then query :=...

[syntax="delphi"]
procedure TForm1.Button1Click(Sender: TObject);
var rezultat:double;
begin
zquery1.Active:=false;
zquery1.SQL.text:='call kasa.suma(5,@izlaz);';
zquery1.ExecSQL;

zquery1.SQL.text:='select @izlaz;';
zquery1.open;
rezultat:=zquery1.Fields[0].Asfloat;
end;
[/syntax]

set ParamCheck with false

Copy file name ZComponent.res to file name ZComponentDesign.res.

ZStoredProc is not implemented for mysql. If you wish to call stored procedure try to ZSQLProcessor. [syntax="delphi"] ZSQLProcessor1.Script.text:= 'Call Newdocument( :CaseRef , :UserID )'; ZSQLProcessor1.ParamCheck:=true; ZSQLProcessor1.ParamByName('CaseRef').AsString := Edit1.Text; ZSQLP...

I have mysql table [syntax="sql"] CREATE TABLE `tabel1` ( `ID` int(11) NOT NULL auto_increment, `Val` int(11) default NULL, `Description` varchar(20) default NULL, PRIMARY KEY (`ID`) ) TYPE=MyISAM; [/syntax] and code: [syntax="delphi"] procedure TForm1.Button1Click(Sender: TObjec...

In my code I non't use StartTransaction.
For begin transaction call function Commit.

For transaction you most have autocomit = false, and call manually Commit and Rollback
In mysql transaction work only innodb tabele.

in my.ini set

#Set the default character set.
default_character_set=latin1

I try with (ÄÖÜ) and work.

MZmuda , All subfolders for folder ZeosLib C:\Program Files\Borland\BDS\4.0\Third_Party_Components\ZeosLib\component C:\Program Files\Borland\BDS\4.0\Third_Party_Components\ZeosLib\core C:\Program Files\Borland\BDS\4.0\Third_Party_Components\ZeosLib\dbc C:\Program Files\Borland\BDS\4.0\Third_Party_...