Search found 164 matches

Go to advanced search

by Wild_Pointer
21.06.2011, 14:37
Forum: PostgreSQL
Topic: Error code/error message from TZConnection with Postgres
Replies: 2
Views: 1670

Hello ccezar,

You should use try... except instead of try finally

Code: Select all

try
  ZConnection1.Connect;
except
  On E:Exception do
  Begin
    ShowMessage(E.Message);
  End;
end;
Good luck
by Wild_Pointer
27.05.2011, 07:51
Forum: 6.6 - stable
Topic: [Solved] Zeos SVN
Replies: 7
Views: 1782

hello JD,

Please use svn://zeos.firmos.at/zeos/trunk

Good luck!
by Wild_Pointer
18.05.2011, 07:18
Forum: MS SQL Server
Topic: Encodeing problem
Replies: 5
Views: 1696

Hello ahmed232323,
I didn't find codePage property in TZConnection?.
well, there isn't. You should enter the line "codepage=utf8" to the TZConnection.Properties . I don't know if that will help for sure, but it's the way it works for postgresql...

Good luck.
by Wild_Pointer
17.05.2011, 07:54
Forum: MS SQL Server
Topic: Encodeing problem
Replies: 5
Views: 1696

Hello, ahmed232323,

May it be that you have forgoten to add codepage=utf8 in the properties of TZConnection? I assume your database is utf8 encoded....

Good luck!

P.S. I'm not working with MSSQL, PostgreSQL is a DBMS I like :)
by Wild_Pointer
04.04.2011, 07:06
Forum: ZeosLib 7.0 Beta Forum
Topic: Insert multiple times gets optimized away.
Replies: 1
Views: 498

marcov , for i:=0 to number-1 do begin qry.execsql; end; should be enough. If you still experience problems try replacing qry.execsql with qry.close; qry.open; commands. It you do only qry.active:=true - only the first time it gets executed as after that qry is active already and no work is done. G...
by Wild_Pointer
21.03.2011, 10:12
Forum: SQLite Administrator
Topic: Please add Horizontal scrall bar on result
Replies: 2
Views: 1639

gavinli , I think you are talking about the TDBGrid component. There are no scroll bars created in zeos. Column width is also a problem of visual data aware component - not zeos. You must realize that dataset object knows nothing (and should not know) the width of the TDBGrid object it is linked to...
by Wild_Pointer
18.03.2011, 08:17
Forum: 6.6 - stable
Topic: Can we install on Lazarus 0.9.31
Replies: 1
Views: 379

Hello, tintinux , please see the links below: http://zeos.firmos.at/viewtopic.php?t=3073&highlight= http://zeos.firmos.at/viewtopic.php?t=3009&highlight= There was some work done in the field, but I'm not sure if the changes were applied to Zeos v6.6. Anyway you can find the patches there to...
by Wild_Pointer
08.03.2011, 08:12
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1024

belvasis,

oh sorry. It's totally my fault... Somehow I managed to miss the mssql as I was looking for sqlserver :). I don't have SQL server to play with now, but maybe I will try to find and test zeos 7 with mssql protocol at work.
by Wild_Pointer
07.03.2011, 08:56
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1024

Hello, belvasis , as zeos does not support protocol to SQLServer you must be using ADO protocol. I have tested on ado protocol and PostgreSql server, and it seems to be ok. On the other hand I'm using Zeos 7 on Delphi. Maybe the error was fixed in v7?... Would you like to try Zeos 7 for your applica...
by Wild_Pointer
06.03.2011, 14:21
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1024

belvasis,

please provide some information on what DB you are using. Also have you tried building test application with the source you have provided? Is the result the same as in your older applications?
by Wild_Pointer
06.03.2011, 10:58
Forum: 6.6 - stable
Topic: Access violation with ExecSQL
Replies: 7
Views: 1024

Hello belvasis,

I'm not that good familiar with zeos versions before 6.6.X, but should you not assign connection object to pQuery before executing it? How does zeos components know what database you are referring to?
by Wild_Pointer
03.03.2011, 06:37
Forum: ZeosLib 7.0 Beta Forum
Topic: Locale messages
Replies: 3
Views: 519

Hello, zapalm,

as you can see you get sql error from your server. Zeos translates messages from it self only (like SUnKnownParamDataType = 'Unknown Param.DataType';). This is expected behavior.

Good luck!
by Wild_Pointer
18.02.2011, 14:49
Forum: ZeosLib 7.0 Beta Forum
Topic: ZConnectionGroup and ZGroupedConnection
Replies: 5
Views: 2264

Anyone willing to do the artwork for those 2 components is welcome here :)
by Wild_Pointer
15.02.2011, 07:09
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 6437

testebelo,

from what I know about MySql Temporary tables they exist until the session (connection ) is active.
If you need to define fields in design time, you can do it by filling them manually (new field from pop up menu).
by Wild_Pointer
14.02.2011, 15:58
Forum: 6.6 - stable
Topic: TZquery dont works with Multiple Statements
Replies: 17
Views: 6437

testebelo , instead do: Connection.ExecuteDirect('START TRANSACTION ISOLATION LEVEL READ COMMITTED;'); with ZQuery1 do begin Close; Sql.Text := 'DROP TABLE IF EXISTS table1 ;'; ExecSql; Sql.Text := 'CREATE TABLE table1 SELECT field1, field2 FROM table2 ; '; ExecSql; Sql.Text :='SELECT * from table1...

Go to advanced search