Search found 1891 matches

by marsupilami
08.05.2024, 10:32
Forum: ZeosLib 7.3/8.0 Forum
Topic: Firebird DB on Android 14
Replies: 7
Views: 488

Re: Firebird DB on Android 14

Hello Sakis,

I just wanted to let you know, I am still working on that but currently have no Android 14 device to debug on. It will take one to two weeks until I have the device back.

Best regards,

Jan
by marsupilami
08.05.2024, 10:31
Forum: ZeosLib 7.3/8.0 Forum
Topic: ERROR: cannot insert multiple commands into a prepared statement
Replies: 8
Views: 431

Re: ERROR: cannot insert multiple commands into a prepared statement

please try this:

Code: Select all

    FQuery := TQuery.Create(nil);
    FQuery.Connection := FConnection;
    FQuery.Properties.Add('emulate_prepares=true'); // <-- this line is new
by marsupilami
08.05.2024, 10:23
Forum: ZeosLib 7.3/8.0 Forum
Topic: Zeos 7.3 testers-thread
Replies: 286
Views: 46623

Re: Zeos 7.3 testers-thread

Hello Michal,

this should be fixed in rev. 8160.

Best regards,

Jan
by marsupilami
08.05.2024, 09:56
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable does not support the ftCurrency type
Replies: 4
Views: 131

Re: ZMemTable does not support the ftCurrency type

I don't have access to any RDBMSes at the moment but it would be interesting to check how TZ(ReadOnly)Query behaves, what kind of field it creates when the query returns an actual currency field. I will be able to test this on Sunday, when I will be back from abroad. According to EgonHugeist Zeos n...
by marsupilami
08.05.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: 497

Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0

Hello,

could you try to create a small sample project (lazarus project + mysql source for function) that demonstrates the problem? This really helps in debugging the problem.

Did you set the ClientCodepage to utf8 or utf8mb4?

Best regards,

Jan
by marsupilami
07.05.2024, 17:23
Forum: ZeosLib 7.3/8.0 Forum
Topic: ZMemTable does not support the ftCurrency type
Replies: 4
Views: 131

Re: ZMemTable does not support the ftCurrency type

I added a TZCurrencyField. TZMemTable should now be able to create a corresponding field. Please test the current version of the 8.0-patches branch . Note: T(Z)CurrencyField is derived from TFloatField - so doesn't do exact numerics. We discourage the usage of this field type. Please use one of the ...
by marsupilami
07.05.2024, 14:58
Forum: Oracle
Topic: How to connect to Oracle without TnsNames.ora?
Replies: 9
Views: 831

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 Conn...
by marsupilami
03.05.2024, 11:41
Forum: ZeosLib 7.3/8.0 Forum
Topic: Firebird DB on Android 14
Replies: 7
Views: 488

Re: Firebird DB on Android 14

Hello, I can confirm the problem. I tried it with some version of Firebird 4 for ARM64. As far as I can see, Exception Class 6 is an Abort Exception possibly caused by SIGABRT. For me this happens, when isc_create_database gets called. I am not sure what causes this exception. Maybe it can be solved...
by marsupilami
02.05.2024, 12:15
Forum: ZeosLib 7.3/8.0 Forum
Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Replies: 16
Views: 497

Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0

Hello meeeeeeeeee,

we added a change to the Zeos 8.0-patches branch. Could you please test and check if it solves your problem?

Best regards,

Jan
by marsupilami
02.05.2024, 08:31
Forum: ZeosLib 7.3/8.0 Forum
Topic: SaveToStream in TZAbstractRODataset
Replies: 1
Views: 60

Re: SaveToStream in TZAbstractRODataset

Hello, Why was the SaveToStream function defined only for the TZAbstractMemTable and not for the TZAbstractRODataset? This is because it was meant to only save the data of TZMemTable ;) Also the stream format is more or less defined to be internal for Zeos. It can change without notice. I'm developi...
by marsupilami
27.04.2024, 09:57
Forum: ZeosLib 7.2 Forum
Topic: cut string field value
Replies: 2
Views: 434

Re: cut string field value

Hello,

we decided that silently cutting strings is a bug because it changes user data. This is why we introduced an exception in these cases. If you want to cut long strings you need to do that yourself before giving the data to Zeos.

Best regards,

Jan
by marsupilami
27.04.2024, 09:49
Forum: User Patches
Topic: Github repo
Replies: 2
Views: 386

Re: Github repo

Hello Mark,

the Github repo should be up to date. I just checked the mesages and saw that the changes from yesterday were pushed to Github. Is there something you miss on Github?

Best regards,

Jan
by marsupilami
26.04.2024, 15:06
Forum: ZeosLib 7.3/8.0 Forum
Topic: Firebird DB on Android 14
Replies: 7
Views: 488

Re: Firebird DB on Android 14

Hello and welcome to the forums,

what error message do you get? I have a small app that uses Firebird 4 locally on Android and it works well.

Best regards,

Jan
by marsupilami
23.04.2024, 09:13
Forum: ZeosLib 7.3/8.0 Forum
Topic: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0
Replies: 16
Views: 497

Re: changed behavior for empty Strings and TZStoredProc on Zeos Ver8.0

Hello meeeeeeeeee,

in which way does sending empty strings fail? Which driver/database are you using? Which compiler version do you use?

Best regards,

Jan