[Firebird-devel] [FB-Tracker] Created: (CORE-5889) events not working - isc_event_block returns different buffer length for same events
events not working - isc_event_block returns different buffer length for same events Key: CORE-5889 URL: http://tracker.firebirdsql.org/browse/CORE-5889 Project: Firebird Core Issue Type: Bug Components: API / Client Library, Engine Affects Versions: 3.0.3, 2.5.8, 3.0.2, 3.0.4 Reporter: Sorien often events are not working in my app I found that for same event like "EVENT_MYTABLE_FOO" isc_event_block returns different buffer lengths like 27 and 7 (FEventBufferLen in code bellow) when it returns 27 everything is working but when i returns 7 app will not get any event it looks like bug for me, but i can't find any documentation for that function, its maybe more support question but really don't know how to use your mailing list :/ code procedure TDBEventThread.RegisterEvents; var sib_event_block: Tsib_event_block; function EBP(Index: Integer): PAnsiChar; begin if (Index > FEvents.Count) then Result := nil else Result := PAnsiChar(AnsiString(FEvents[Index - 1])); end; begin FEventBuffer := nil; FResultBuffer := nil; FEventBufferLen := 0; FFirstTime := True; FEventCount := Min(FEvents.Count, IB_MAX_EVENT_BLOCK); sib_event_block := Tsib_event_block(FPlainDriver.GetFirebirdAPI.isc_event_block); FEventBufferLen := sib_event_block(@FEventBuffer, @FResultBuffer, FEventCount, EBP(1), EBP(2), EBP(3), EBP(4), EBP(5), EBP(6), EBP(7), EBP(8), EBP(9), EBP(10), EBP(11), EBP(12), EBP(13), EBP(14), EBP(15)); end -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] [FB-Tracker] Created: (CORE-5888) Firebird server on Android have problem with numerics
Firebird server on Android have problem with numerics - Key: CORE-5888 URL: http://tracker.firebirdsql.org/browse/CORE-5888 Project: Firebird Core Issue Type: Bug Components: Engine Affects Versions: 3.0.3 Environment: Android 8.0 Firebird version: LI-V3.0.3.32900 Reporter: Karol Bieniaszewski Any select from Firebird containing numeric data type cause "Fixed length column [F_NUMERIC] data length mismatch. Value length - [2], column fixed length - [8]" when run from Delphi Firedac. Same select throught firebird client to remote server works ok. It looks like (from Firedac error message) that this is metadata/buffer retrurn problem to the client. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://tracker.firebirdsql.org/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Hi, > Certainly - it's very hard to have remote connections w/o appropriate > provider ;) i supposed that provider is for Firebird Server not for client library. > Yes - seems to be so. > Please add a ticket to the tracker - I will try to find time to > reproduce and fix it. > A. created CORE-5888 > > PS. What does isql do with numerics when started on Android? > How to run isql on Android? regards, Karol Bieniaszewski -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
On 10.08.2018 10:26, liviuslivius wrote: Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf Providers = Engine12, Remote then another success :) Certainly - it's very hard to have remote connections w/o appropriate provider ;) i have connected from Delphi Firedac on Android to remote firebird without any issues (numerics are ok). Tested with newer Firebird WI-V3.0.4.32954 Firebird 3.0 and then with same version Firebird-3.0.3.32900_0_x64 to remove possibility that something was bad only with older version. It looks like client library work ok only Firebird server on Android have some bug releated to Numerics. Yes - seems to be so. Please add a ticket to the tracker - I will try to find time to reproduce and fix it. A. PS. What does isql do with numerics when started on Android? -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Hi, i have tested this more detailed. I have created TCP socket on computer and TCP client on Android side and communication was established. But when i have tried by firedac(and client lib) it did not even tried. Then i have changed in firebird.conf Providers = Engine12, Remote then another success :) i have connected from Delphi Firedac on Android to remote firebird without any issues (numerics are ok). Tested with newer Firebird WI-V3.0.4.32954 Firebird 3.0 and then with same version Firebird-3.0.3.32900_0_x64 to remove possibility that something was bad only with older version. It looks like client library work ok only Firebird server on Android have some bug releated to Numerics. regards, Karol Bieniaszewski -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel