ErrorCode -607 when creating tables (Lazarus+Zeos+Firebird)
Posted: 11.07.2008, 13:41
I'm using firebirdd-2.0 protocol (but I tried also with 1.5), Zeos 6.5.1 and Lazarus 0.9.24.
This is my code:
When I put in my listbox:" create table MyTable(col1 integer, col2 integer)" it works succesfully, but if I try to create a table with a varchar field "create table MyTable(col1 integer, col2 varchar(20))" it returns 'ErrorCode -607'.
Can somebody help me ?
Thank you
This is my code:
Code: Select all
procedure TForm1.Button2Click(Sender: TObject);
begin
ZConnection1.User:='sysdba';
ZConnection1.Password:='masterkey';
if not ZConnection1.Connected then
begin
ZConnection1.Database := 'db1.fdb';
ZConnection1.Connect;
if ZConnection1.Connected then showmessage('Connesso');
end;
ZQuery1.Connection:=ZConnection1;
try
ZQuery1.SQL.Clear;
ZQuery1.SQL.Add(edit2.text);
ZQuery1.ExecSQL;
except
on E : EZSQLException do
begin
// zconnection1.Rollback;
ShowMessage('ErrorCode : ' + IntToStr(EZSQLException(E).ErrorCode)+' '+EZSQLException(E).StatusCode );
end;
end;
ZQuery1.SQL.Clear;
end;
Can somebody help me ?
Thank you