Search found 10 matches
- 21.05.2024, 02:27
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello. I tried current snapshot and my problem was fixed! thank you!
- 17.05.2024, 01:35
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello.
Best regards
Thank you for the tip! This makes sense!Maybe it makes sense to call parameters by name (ParamByName) instead of calling them by Index?
I'll wait until it will be fixed!There is a bug in Zeos preventing you from using the procedure. I will have to see what I can do.
Best regards
- 15.05.2024, 01:47
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello. With your most Recent patch that you added for Mariadb, I could solve my error! Thank you very much! And I encountered another error... How Can I get "OUT" result of StoredProcedure? Has it changed something with it with Zeos8.0 too? Error message :SQL Error:Out or INOUT argument 9 ...
- 14.05.2024, 06:42
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
No error from command line..... select test_zeos_2func(0, 'db_master_'); +----------------------------------+ | test_zeos_2func(0, 'db_master_') | +----------------------------------+ | select * FROM db_master_zeos | +----------------------------------+ *Error Message from ZStoredProc1 Unsupported p...
- 14.05.2024, 06:41
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
No error from command line. select test_zeos_func('test_zeos'); +-----------------------------+ | test_zeos_func('test_zeos') | +-----------------------------+ | select * FROM test_zeos | +-----------------------------+ *This is Error Message from ZStoredProc1 Unsupported parameter type, SQL Type:st...
- 14.05.2024, 06:34
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello. I created a small sample project. I set ClientCodepage to utf8mb4. I would be grateful, if you'd check it. I couldn't post my small sample project at once, so I separated to 3 parts. ********************** * Lazarus3.2+Zeos8.0.1-beta ********************** TForm1 = class(TForm) DataSource1: T...
- 08.05.2024, 08:10
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello. marsupilami. I downloaded "zeoslib-code-0-r8159-branches-8.0-patches.zip" from the link. I copied "examples","packages" and "src" folders over the folder "zeosdbo", then installed into Lazarus3.2. "TZconection" component-version show...
- 07.05.2024, 05:21
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello, marsupilami! Thank you very much for the Zeos 8.0-patches, but I've never used the Zeos 8.0-patches before.
So could you kindly tell me where I can download this file and how to use it?
Thank you
So could you kindly tell me where I can download this file and how to use it?
Thank you
- 23.04.2024, 09:53
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Hello.Jan,
I'm using Lazarus3.2 and MariaDB(version 10.6.14) with Windows 11.
And MariaDB database Engine is InnoDB.
I can send Empty string in command-line into MariaDB stored procedures.
My English isn't good, so if you don't understand well what I'm saying, my apology.
I'm using Lazarus3.2 and MariaDB(version 10.6.14) with Windows 11.
And MariaDB database Engine is InnoDB.
I can send Empty string in command-line into MariaDB stored procedures.
My English isn't good, so if you don't understand well what I'm saying, my apology.
- 23.04.2024, 07:06
- Forum: ZeosLib 7.3/8.0 Forum
- Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
- Replies: 16
- Views: 517
changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
I'd like to ask about newest version Zeos8.0. Zeos 8.0 's TZStoredProc does'nt allow sending empty strings to stored procedures. I can send empty strings by using previous version Zeos version 7.2.14.0. I do like this ZStoredProc1.StoredProcName :=xxxxx ZStoredProc1.Params[0].AsInteger :=1; ZStoredP...