Zeoslib Portal

Hello, testebelo , you could set AutoCommit to false, TransactionIsolation to tiNone to your Connection object, then start your own transaction by calling executedirect('START TRANSACTION ISOLATION LEVEL READ COMMITTED;'). Then call as many SQL statements as you need (creating and using temp tables)...

Betus , try reading http://zeos.firmos.at/viewtopic.php?t=2760&postdays=0&postorder=asc&highlight=zconnectiongroup&start=0 these two components are needed to have several connections to the same server without filling connection parameters all the time. You fill the parameters only ...

vannus , i would discourage you using ZTable on tables that are growing as it will slow your application in future. ZTable is good for tables of not changing data - that you write once and new records are added rarely. If the table is used for general operation (sales, logging and so on) then the Z...

However during TZAbstractRODataset.InternalOpen which happens later on, those values get changed - my 200 length fields become 255 - my 5000 length fields become 1000 This is really strange as I observed no such behavior with postgres (with fields less than 255 char long). I expect Postgres and SQL...

vannus,
Did you look into Does it return correct fieldtype and precision?

vannus , I can not help you alot with SQLite as I'm not using it, but maybe there are some analogy with Postgresql. I noticed, that I also get long varchar fields truncated to 255. The answer to "why?" lies in libpq - client library to postgres. Somehow if the field is bigger than 255 the...

Hello pomalo , 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 v7. Anyway you can find the patches there to make...

hello tintinux , would you please provide the code sample how you try to obtain the tablenames?... I tried ZConnection1.Connect; ZConnection1.GetTableNames('', 'public', Memo1.Lines); ZConnection1.Disconnect; It provided me the tables of the public schema. I use Lazarus 0.9.28.2-10ubuntu1 FPC 2.4.0 ...

vannus,

please tell what DBMS you are using (Postgresql, Firebird or other), what version of Zeos library you have, OS and compiler (Delphi, Lazarus..) with version.

JD,

I'll sugest you read http://zeos.firmos.at/kb.php?mode=article&k=9 That will give you several thoughts to start with when using Postgresql.

Good luck!

mdaems , in line 218 of the file you send is a line function TAggregatedObject._Release: Integer; {$IFNDEF WINDOWS}cdecl{$ELSE}stdcall{$ENDIF}; Do you know why is it there? I meen the calling directives. mmvisual removed them and I think the source is better now. On the other hand if they are neede...

Hello, mmvisual , there's already a topic about the problem of FPC >= 2.5. http://zeos.firmos.at/viewtopic.php?t=3009&highlight=fpc Have you read it? Also have you tried compiling zeos lib on lower FPC version with your changes applied. Is it backwards compatible? Didn't you have to also change ...

Happy New Year Zeos community!!! May this year bring even more contributors to this project!

Hello, martinrame,

this error was because of improper use of connection handle in statements. Please read http://zeos.firmos.at/viewtopic.php?t=2599&highlight=

Good luck!

Hello, mdaems , I'm using Lazarus 0.9.28.2-10Ubuntu1, FPC v2.4.0 objpash.inc contains declaration: IUnknown = interface ['{00000000-0000-0000-C000-000000000046}'] function QueryInterface(const iid : tguid;out obj) : longint;stdcall; function _AddRef : longint;stdcall; function _Release : longint;std...