Search found 10 matches

by meeeeeeeeee
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!
by meeeeeeeeee
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.
Maybe it makes sense to call parameters by name (ParamByName) instead of calling them by Index?
Thank you for the tip! This makes sense!
There is a bug in Zeos preventing you from using the procedure. I will have to see what I can do.
I'll wait until it will be fixed!
Best regards
by meeeeeeeeee
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 ...
by meeeeeeeeee
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...
by meeeeeeeeee
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...
by meeeeeeeeee
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...
by meeeeeeeeee
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...
by meeeeeeeeee
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
by meeeeeeeeee
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.
by meeeeeeeeee
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...