Search found 784 matches

by aehimself
17.11.2024, 16:57
Forum: Oracle
Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Replies: 34
Views: 2540

Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)

Can you narrow it down to the exact record or column that causes the problem? I don't know how much you changed the buffer logic, but previously it was not possible. It was not one record, but the amount of data handled UNTIL a specific number of records... I remember changing the order by, adding ...
by aehimself
17.11.2024, 13:49
Forum: MySQL
Topic: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp
Replies: 3
Views: 67

Re: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp

Searching around pops different error messages for the same source file in .net so I'm not sure in which direction to go. It would be nice to have a full exception message and a stack trace. I suspect a .net issue - my guess is the new library was written in that. As you are connecting to MariaDB, c...
by aehimself
14.11.2024, 09:13
Forum: Oracle
Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Replies: 34
Views: 2540

Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)

Unfortunately the result is the same, returned value is still truncated.
by aehimself
14.11.2024, 08:09
Forum: User Patches
Topic: GetSequence metadata for Oracle
Replies: 2
Views: 64

Re: GetSequence metadata for Oracle

I may be misunderstanding, but for Oracle catalog should be empty and schema should be the SEQUENCE_OWNER column of ALL_SEQUENCES. I started my journey with MySQL and MSSQL and things were a lot more easy to understand there. I will be completely honest, I am totally lost in this Oracle naming madn...
by aehimself
12.11.2024, 22:21
Forum: MySQL
Topic: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp
Replies: 3
Views: 67

Re: onecore\net\netprofiles\service\src\nsp\dll\namespaceserviceprovider.cpp

Seems to be a Windows 11 and old lib library issue: https://stackoverflow.com/questions/706 ... und-in-the

What version is your server and client DLL?
by aehimself
12.11.2024, 17:43
Forum: User Patches
Topic: GetSequence metadata for Oracle
Replies: 2
Views: 64

GetSequence metadata for Oracle

Hello,

Since I needed it and it was not yet implemented I added the sequence collection for Oracle.
Unfortunately I was unable to find how I can connect a sequence to a catalog and a schema (if it can be at all) so those fields are left empty.

Pull request is available on GitHub as usual.

Cheers!
by aehimself
12.11.2024, 17:37
Forum: Oracle
Topic: Oracle & UTF16 - Fetched column value was truncated (solved...?)
Replies: 34
Views: 2540

Re: Oracle & UTF16 - Fetched column value was truncated (solved...?)

Unfortunately it seems that while Mark's fix indeed makes things better, does not solve the actual issue. While I was implementing sequence metadata for Oracle I was greeted with: [2024. 11. 12. 17:31:16] db: Prepare Statement 33 : SELECT * FROM ALL_TRIGGERS [2024. 11. 12. 17:31:16] db: Prepare Stat...
by aehimself
17.10.2024, 16:52
Forum: ZeosLib 7.3/8.0 Forum
Topic: How to replace TZParam.LoadFromFile
Replies: 2
Views: 74

Re: How to replace TZParam.LoadFromFile

A quick google search will give you the knowledge you are looking for. No, it does not mean you have to type "overload", but to use an other, overloaded version. The error message means the method you are calling is deprecated and possibly will be deleted soon. So you should call other met...
by aehimself
16.10.2024, 23:40
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 12
Views: 1543

Re: How to connect to Oracle without TnsNames.ora?

because I feel it is counterintuitive for users to explicitly enable Zeos to use easy connect syntax? You are absolutely right. If we find a way to reliably make it automatic it makes sense to be on by default. But is it a breaking change to introduce this? From a Zeos perspective the behavior is u...
by aehimself
05.10.2024, 15:04
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 12
Views: 1543

Re: How to connect to Oracle without TnsNames.ora?

I am sorry to resurrect this thread but I wonder why we don't add a possibility for Zeos to internally create a correct connection string? Something like: if HostName <> '' then begin ConnStr := '//' + HostName; if Port <> 0 then ConnStr := ConnStr + ':' + IntToStr(Port); if Database <> '' then Con...
by aehimself
14.09.2024, 20:59
Forum: ZeosLib 7.3/8.0 Forum
Topic: TZAbstractConnection.ConnectionLost issue
Replies: 2
Views: 108

Re: TZAbstractConnection.ConnectionLost issue

It won't be false, if a custom exception is raised and handled WITHIN the event handler itself... like Procedure TConnection.OnLost(Sender: TObject); Begin Raise Exception.Create('Connection to the database server was lost, please call 911'); End; If no custom exception was raised we create and rais...
by aehimself
12.09.2024, 20:24
Forum: ZeosLib 7.3/8.0 Forum
Topic: AbortOperation issue
Replies: 9
Views: 213

Re: AbortOperation issue

I would also like to recommend a change of code in TZDbcPooledConnection.AbortOperation , The way it works now is that if it doesn't have a connection it obtain one only to abort it immediately. This is a waste. It should first check whatever the connection IsClosed and if not try to abort it. if i...
by aehimself
11.09.2024, 20:34
Forum: ZeosLib 7.3/8.0 Forum
Topic: AbortOperation issue
Replies: 9
Views: 213

Re: AbortOperation issue

I use Firebird on a daily basis. What tests should I do? Jan, This is the comment I put in .AbortOperation for Firebird: // This is a mess and probably doesn't work as intended. cIStatus_RESULT_OK is 0, which means it doesn't matter what // getState returns, anything AND 0 will be 0. Therefore, 0 <...
by aehimself
09.09.2024, 09:50
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 962

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

Since it is 100% Delphi 7 compatible I issued a pull request on GitHub. I don't have any real-world application to test it on though so I'll leave that to the community :)
by aehimself
08.09.2024, 14:35
Forum: ZeosLib 7.3/8.0 Forum
Topic: Lazarus - TZUpdateSQL not bringing its update fields selected
Replies: 15
Views: 962

Re: Lazarus - TZUpdateSQL not bringing its update fields selected

I did a minimal example and I can confirm that 1, Under Delphi 7 TListBox has .Selected[], .TopIndex and .SelectAll methods 2, Setting .Selected[] or invoking .SelectAll indeed moves the node in question to be visible (they do scroll the scrollbox) So, the below code is the most efficient and fool-p...