Zeoslib Portal

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... :(

Am I the crazy here or something fancy is going on :) I have a TZReadOnly query, with the following SQL: SELECT [...] FROM MyTable WHERE SomeField = :pID ORDER BY ID ASC When the user changes to a different option, the query is closed, parameter value is updated and is being reopened. All is connect...

It's not an inconvenience at all but at least easy to reproduce. Have a ZMemTable, a datasource and a DBGrid connected on your blank app, and write the following code: procedure TForm1.FormCreate(Sender: TObject); begin ZMemTable1.FieldDefs.Add('ID', ftLargeInt, 0, True); ZMemTable1.FieldDefs.Add('T...

Maybe "Oracle Label Security"? ;) We recently upgraded our Oracle installations to 19, so it fits... The reasons I have doubts are: 1, According to Oracle's website, Label Security is based on users, and both tools used the same user to log on 2, 3-4 hours later the records showed up in t...

Hello, I have a strange situation here. I connect to the same database from the same TNSNames.ora descriptor with the same user, password and schema, using the same oci.dll with my application using Zeos and PL/SQL and execute the same query: SELECT ID FROM MyTable WHERE ID = xxx Now, PL/SQL happily...

Zeos 8 includes the TZTransaction object for this exact purpose I suppose :)

Something is still not good with UTF16 Oracle and a number of VarChar columns. Setting INTERNAL_BUFFER_SIZE to a high enough number will get rid of the Oracle error, but can result in empty fields, whereas the database does contain data: Untitled.png Why it's really problematic is that false data is...

Okay, let's give it a spin on Jenkins. Pull request is available on GitHub.

Inserting the same set of checks into TZCachedResultSet.FillColumnInfo actually solves the issue: If ColumnType In [stString, stUnicodeString] Then If ColumnCodePage = zCP_UTF16 Then ColumnType := stUnicodeString Else ColumnType := stString; Now the question is... which protocol supports UTF16? I ca...

TZCachedOracleResultSet is derived from TZCachedResultSet, so... :) The only impactful difference is in the method FillColumnsInfo: Orcale version sets the ColumnType to stUnicodeString, the regular to stString... and if I change the type from the debugger to stUnicodeString, no more corruption happ...