Zeoslib Portal

- Which version of Zeos do you use? Do you use the latest ZIP or do you get your Zeos from SVN? Stable 7.2.4 - Which RDBMS do you use? And which Version of that RDBMS? Firebird 2.5 - Which OS do you use and which version of that OS? Windows 10 - Which Version of Delphi or Lazarus/FPC do you use? 200...

Goes without saying that I cleared a few times the dcu's and I fully deleted the Zeos folder and uncompressed from downloaded zip afresh

{** written by FrOsT} function TZDefaultIdentifierConvertor.GetIdentifierCase( const Value: String; TestKeyWords: Boolean): TZIdentifierCase; ... begin ... { Checks for reserved keywords. } if Metadata.GetDatabaseInfo.StoresUpperCaseIdentifiers and (Result <> icUpper) then S := UpperCase(Value) els...

I have this error in 2007 and D7.2.4, only now it's manifesting as [DCC Error] ZDbcResultSet.pas(363): E2211 Declaration of 'GetULong' differs from declaration in interface 'IZResultSet' [DCC Error] ZDbcResultSet.pas(363): E2211 Declaration of 'GetULongByName' differs from declaration in interface '...

Thank you
It seems to rely exclusively on the primary keys in DB (I mean the sql where clause)
Is there any way I can pass the index field name via TZTable parameters? I don't have the actual primary key in the DB for that table.

Hi, I wonder if it possible to only include the actually changed fields in TZGenericCachedResolver.FormUpdateStatement? My problem is that my program is being used in the multi-user environment and sometimes users change the same record (but different fields) from different connections. Since all fi...

Perfect! This code works like a charm procedure TForm2.Timer1Timer(Sender: TObject); begin Timer1.Enabled := false; with TZQuery.Create(nil) do try ZConnection1.StartTransaction; SQL.Text := 'update nextrans set pizza=pizza+1 returning pizza'; Connection := ZConnection1; Open; Caption := Fields[0].A...

Hi, I can't get concurrent updates working I created a new test program that only has a ZConnection component with Transaction Isolation set to read commited, and a Timer. The timer code is this: procedure TForm2.Timer1Timer(Sender: TObject); begin Timer1.Enabled := false; ZConnection1.AutoCommit :=...

Hi all,

It seems that the firebird3 driver in zeoslib is just a copy of firebird25 which means no real protocol updates?
The one that interests me is the new compression feature introduced in firebird3

Can you maybe point me to delphi firebird components supporting ver3 compression?

Does Ping not only work for if there is a connection already?
I.e. you can't test for Ping before Connect

marsupilami wrote:Could you please check, wether it solves your problem?

Thanks a lot. The datasets are not readonly anymore

Hello duzenko, it is my experience that you will get editable fields if you provide information about the field source to the upper layers of Zeos. Take a look at the code of TZDBLibResultSet.Open in ZDbcDbLibResultSet.pas. It provides information about the fields to the component layer of Zeos. Bu...

Hi Jan,

I'm using protocol FreeTDS_MsSQL>=2005 (same thing with mssql) and the appropriate dblib.dll (ntwdblib.DLL)
Server version is 2008 R2
Any help is greatly appreciated

I have a software that is supposed to function across a number of different sql servers Right now I have it more or less working with Firebird, MySQL and SQLite I am now tasked to add support of MS SQL The problem is, my software (ported from dbaseIV) makes use of many TZQuery's Edit and Insert meth...

I just updates to the latest version in svn and it's all the old bugs again 1) firebird sql keyword list not full 2) "_" symbol treated as wildcard in table names it's all been there for years now http://zeos.firmos.at/viewtopic.php?t=3077&start=0&postdays=0&postorder=asc&h...