Zeoslib Portal

project *** raised exception class 'EZSQLException' with message:
SQL error: You have an error in your SQL syntax; check the manuel that cooresponds to your mysql server version for the right syntax to use near 'LIKE '%'' at line 1.

in file 'D:\lazarus64\components\zeoslib\src\ZDbcMysqlUtiles.pas' at line 470.

Can you tell me more details about this problem? I Can't run the testsuites for fpc/dbc-layers for lazarus. So please tell me detailed your Config-details..

Best regards

EgonHugeist

unit Unit1;

{$mode objfpc}{$H+}

interface

uses
Classes, SysUtils, FileUtil, ZConnection, ZDataset, Forms, Controls, Graphics,
Dialogs, StdCtrls;

type

{ TForm1 }

TForm1 = class(TForm)
Button1: TButton;
ZConnection1: TZConnection;
ZQuery1: TZQuery;
procedure Button1Click(Sender: TObject);
procedure FormCreate(Sender: TObject);
private
{ private declarations }
public
{ public declarations }
end;

var
Form1: TForm1;

implementation

{$R *.lfm}

{ TForm1 }

procedure TForm1.Button1Click(Sender: TObject);
begin
with ZQuery1 do
begin
Connection:=ZConnection1;
active:=false;
sql.Clear;
sql.Text:='select * from empresa';
open;
end;

end;

procedure TForm1.FormCreate(Sender: TObject);
begin
with ZConnection1 do
begin
ZConnection1.HostName:='localhost';
ZConnection1.User:='zeoslib';
ZConnection1.Password:='lazarus';
ZConnection1.Port:=3306;
ZConnection1.Database:='lazarus';
ZConnection1.Protocol:='mysql-5';
ZConnection1.Connect;
//ZConnection1.Connected:=true;

end;

end;

end.

picture2

picture3

with lazarus win32, this do fine..

picture4

Give example mysql database dump with example lazarus project in archive

wylton,
I'll try my best to help you. Can you also tell me which ClientCodePage do you use? Have you updated your Zeos-Rev.? If the thread-Rev. is right then you use my private expermintal one you have to know. And actually i'm hardly working on it. There are nearly dayly Rev-upgrades. I think it's a compatibility problem of the new FPC 2.6.

ism, are you fpc2.6 user?

Best regards

this is only problem of X64 fpc 2.6.. I have tested on X32 fpc 2.6.0, work fine. I haven't use any ClientCodePage in Zconnection and ZQuery.
my windows is windows 7 in chinese.
I have trid with rev943 and rev1008(?).
sorry my ingles....

ism wrote:Give example mysql database dump with example lazarus project in archive

que es lo que necesitas? backup mysql database con Lazarus?
en windows o Linux? para backup, puedes utilizar process de Lazarus.

Your english does'nt matter... Which branch have you downloaded? trunk or testing or testing-egonhugeist? If the last one then refresh your SVN... and tell me if the erreors happens again..

EgonHugeist wrote: ism, are you fpc2.6 user?

No , but I can easily install it , I am interested in the reliable work of zeosdbo (i use it in my projects) and can test it

ism,

which compiler is your prefered one? I need some test-developers for my private testing-branch. Some detailed bug-reports are helpfull or additional thougth...

Are you fpc or delphi user?

now I update to zeoslib - Revision 1017: /branches/testing..
problem is same.