Zeoslib Portal

Hello Joe, this really is strange. In TZQuery the insert statement is auto-generated, how can i manipulate this ? I even don't know, why this " is auto-generated only for my "STATUS" field. Seems mysterious to me... You could use TZUpdateSQL to provide your own statements, so Zeos doe...

Hello Enrique,

usually this would be part of the connection string. Mabe a look at https://www.connectionstrings.com/ can give you an idea?

Please note: We want to discontinue support for ADO. You might want to check if your application works correctly with the OLEDB driver.

Best regards,

Jan

Hello,

there seems to be an hard to fix issue with the way we handle calculated fields. We are currently investigating this. I willanswe when we have a solution ready.

With best regards,

Jan

Hello marko, the PostgreSQL driver changed from scharacter bindings to binary bindings. There may be a problem when converting some data to the Postgres binary formats. One idea might be to first switch from inserting multiple rows to single rows, so we have a chance to figure out which value actual...

Hello :) For being able to do better debugs, I modified the Options in the >Configure "Build Lazarus"< Dialog from "-g -gl -O1" to "-gw3 -gl -O1". Also I modified all the Zeos packages to use the "Dwarf 3" debug type info. This can help. One note: Since I see ...

Hello,

the issue has been fixed. Please download a current snapshot of the 8.0-testing branch.

Best regards,

Jan

Hello Marcelo,

I added the VER370 defie to the list of the problematic release too. I assume that is what Emarcadero uses for Delphi 12.1?

Best regards,

Jan

Hello, again your code needs to be different: ZStoredProc1.Close; ZStoredProc1.StoredProcName :='test_zeos_3proc'; ZStoredProc1.Params[0].value :='test_zeos'; ZStoredProc1.Prepare; ZStoredProc1.Open; memo1.Lines.Add(ZStoredProc1.Params[1].value); ZStoredProc1.Close; This time you are calling a store...

will that work in a multi-layered system? Since the executedirect will be ran directly on the database before the query gets assembled and executed, some other query might be ran in the meantime, won't that cause issues? If you keep to the Zeos rules for multi threading, then yes - it should work. ...

in lazarus 3.99 with fpc 3.2.2. no error, with fpc 3.3.1 access violation error I tried to run the test suite and have similar errors with Firebird 3. We do think this is a compiler problem but are not sure yet on how to proceed. If you need to work with Firebird on the trunk compiler, please switc...

Hello, lazarus win32/win64 ver. 3.99 fpc 3.3.1 firebird 3.0 http://svn.code.sf.net/p/zeoslib/code-0/branches/8.0-patches error in file src\plain\ZPlainFirebird.pas function IMaster.getStatus(): IStatus; begin Result := MasterVTable(vTable).getStatus(Self); end; I am not sure what the problem is in t...

Hello, from the release notes: For database systems, where a return value is defined, like MS SQL Server, the return value has moved to ordinal position 0. This change affects dblib based drivers (MS SQL Server / Sybase Adaptive Server Enterprise) as well Oracle, MySQL / MariaDB, OLEDB, ODBC and ADO...

Hello, maybe you should split your statements then: procedure TLicenca.LimparAuth; var teste: string; begin with FQuery do begin SQL.Clear; if not Schema.IsEmpty then FQuerry.Connection.Executedirect('SET search_path = ' + QuotedStr(Schema)); // <--- This is changed SQL.Add('DELETE FROM autorizacao'...

Hello Stefano,

I wonder about the use case for this. But there ist is - AssignTo for TZRawCharacterTransliterateOptions. Check the latest revision of the 8.0-patches branch.

Best regards,

Jan

Hello Michal,

the warnings should be fixed now.

Best regards,

Jan