Zeoslib Portal

Just an fyi, if someone is interested. I wrote a descendant of TZGenericStatementAnalyser which can parse all table aliases, even if multiple SQL commands are provided. For the solution, you can visit this topic on DelphiPraxis , where the reason behind is also explained. @ Jan, If you think it has ...

Hello, Of course you can use TZQuery (even for changing field values) but only for simple queries. In case you have a join or such, Zeos will even throw an exception to tell you that it won't work. Only in those cases you need a TZUpdateSQL to tell Zeos how exactly to assemble your INSERT / UPDATE q...

The real world test is to call GetIndexInfo on a MySQL table that contains both a primary key and also a non-unique index. You should see the NON-UNIQUE column for the non-unique index = false (which is incorrect.) Strange, even in my own home-cooked application I have plenty of tables like this an...

That's odd. I've tested it quite a bit. What do you get if you put this code in that function (at that same line)? Note that the dataset's type for IndexInfoColNonUniqueIndex is a boolean and the existing code tries to set it as a string (and I think the logic of it is incorrect regardless.) Don't ...

@ Mark,

How did you get this error? I'm using Zeos with MySQL on a daily basis and never seen it returning everything as unique.
Do you maybe have a test case?

Cheers!

I support the second option, especially since MSSQL does this the same way (sending the USE command after login).

Which version? Which package? Any error messages? What steps did you do until you got the error?

None of us has a crystal ball. Please try to be more specific.

I have 0 experience with PG; however, the above statement looks like an SQL command.

Did you try ?

The way I am handling these things is: - Have all components on the VLC form. DB aware components are allowed and working well. - Before any background operation, disconnect all DB aware components from their datasources - Show your "loading" screen - Create and execute a thread which only...

Just to be sure - it is the thing over here? https://zeoslib.sourceforge.io/viewtopic.php?f=37&t=152220 Yes, that is the nasty one. Reading the whole thread back makes it funny how much progress was already made compared to the initial state. Anyway, I'll jump out from this thread as I'm being ...

marsupilami wrote: ↑06.07.2022, 08:08But I have doubts wether this will fix your problems.

Yep. Didn't help :(

Can't wait for this to show up in Git. Maybe it fixes my Oracle UTF16 issue as well...

Hello, Today I got a "Duplicates not found" error when I enumerated the existing properties for a specific protocol; the issue was with the property named 'KRB'. I checked it back it pointed me to the two properties above, which are described in ZPropertiesEditor.pas as follows: ZProp_Kerb...

A side note for me: For constructing an automated test, it migt make sense to determine the current connection ID using the CURRENT_CONNECTION context variable (see here ) and create a second connection for disconnecting the original connection. This way no user interaction would be required. If yo...

Please disregard this post. The issue was me, leaving a tiny piece of code somewhere else which manually reset the .SortedFields property.
Zeos is working fine, I just need to sleep more... :(