Zeoslib Portal

Hello :) this is a known issue. We changed to an API function that seems to prepare staements inernally although it isn't documented. Please add the emulate_prepares parameter to get your query working again: Query.SQL.Add('SET search_path = %s;' schema); Query.SQL.Add('SELECT * FROM %s;' tablename)...

Anyway, it looks like the deliberate change was that query is closed if assigned SQL.Text is different than previous one, but not close if assigned SQL.Text is the same? Yes - that is the deliberate change. There is some ressource intensive work that we have to do if the SQL changes. If you want to...

Hello cappelletto,

with persistent fields these things can happen. Zeos 8 introduced new field capabilitis and it changed the reules about which field type gets generated at which time.

Best regards,

Jan

Hello dseligo, How can I turn on behavior like it was in previous Zeos versions? I think you can't. This was an intentional change by Egonhugeist. See the following code from ZSqlStrings.pas: procedure TZSQLStrings.SetTextStr(const Value: string); begin if Trim(Value) <> Trim(Text) then //prevent re...

Hello Mark,

I sent a PM to you with alternate upload information.

Best regards,

Jan

Hello Mark,

do you have a test application and test data that you can share?

Best regards,

Jan

The Zeos Team is proud to announce the availability of Zeos 8.0.0 as a stable release. This is the newest stable version of Zeos. It deprecates Zeos 7.2, and any previous version of Zeos. We urge all people still using older versions of Zeos to upgrade. If you have any problems with Zeos 8.0, please...

It seem sthe problem was fixed upstream (Commit 886f91de). Unfortunately I cannot get Lazarus and FPC to build in their trunk versions so I cannot test easily.

Hello zeosbow, welcome to the forums :) You seem to use FPC trunk for compilation. We don't support FPC trunk because it is a moving target. The problem in this case is that they added a variant type (varUInt32) but didn't extend the TVarData record accordingly. I created a ticket to see if they wil...

Hello, I fixed this for Zeos 8 in rev. 8093. It should show up on github tomorrow.

Hello hamacker, I think the best way to operate on Lazarus is to work with UTF8 on all levels: ClientCodePage=UTF8 ControlsCodePage=cCP_UTF8 This way you don't have to change the RawCharacterTranslitarateOptions from the defaults and no character set transliteration needs to be done in your program ...

Hello kikep, soo - I tried to setup a tes environment but whatever I do - using the Zeos ODBC driver I get an access violation. (Access violation at address 754A45E0 in module 'KERNELBASE.dll'. Read from address 00000318.) What works for me is: Setup a DSN in the ODBC admin interface Use the Zeos Ol...

Hello kikep,

I wiull have to build some kind of test virtual machine to test this because I cannot install the software required on my production systems. That will take some time.

I will get back to you as soon as I have new results.

With best regards,

Jan

Hello iteh,

I am sorry for the delay. I am moving currently. I will check this during the easter holidays.

With best regards,

Jan

Hello Vodnik, the ODBC drivers in Zeos only workes with ODBC connectrion strings until now (see https://www.connectionstrings.com). To connect to a DSN you would have to siupply a connection string like 'DSN=ODBC_Informix'. The change from today checks if there is a = in the database name. If there ...