Jump to content

Dmitry Arefiev

Members
  • Content Count

    79
  • Joined

  • Last visited

  • Days Won

    2

Everything posted by Dmitry Arefiev

  1. Dmitry Arefiev

    Firedac - Sqlite - DateTime field

    Most right way will be to create an issue at quality.embarcadero.com. And attach the DB file with the words explaining what you did. I would expect, dates were inserted using format not supported by FireDAC.
  2. Dmitry Arefiev

    Firedac - Sqlite - DateTime field

    Sorry for spamming, dont know how it happened ...
  3. Dmitry Arefiev

    Firedac - Sqlite - DateTime field

    You have to read: http://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_SQLite_with_FireDAC#SQLite_Data_Types http://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_SQLite_with_FireDAC#Adjusting_FireDAC_Mapping
  4. Dmitry Arefiev

    Firedac - Sqlite - DateTime field

    You have to read: http://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_SQLite_with_FireDAC#SQLite_Data_Types http://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_SQLite_with_FireDAC#Adjusting_FireDAC_Mapping
  5. May be this will help: https://support.microsoft.com/en-us/help/3140245/update-to-enable-tls-1-1-and-tls-1-2-as-default-secure-protocols-in-wi
  6. 1) If server is publicly accessible, please, log this issue to quality.embarcadero.com and attach simple test project. If there is some sensitive information, which you dont want to share publicly, then let me know. We can exchange it privately. 2) Otherwise, you can try to analyze the server using https://www.ssllabs.com/ssltest/ This may give some hints.
  7. Try to leave only TLS v 1.1 and 1.2 in SecurityProtocols.
  8. Please report this issue to quality.embarcadero.com, and get it fixed in 10.4 Update 1.
  9. Dmitry Arefiev

    Up-to-date 32 bit libmysql.dll?

    Start from this link: https://dev.mysql.com/downloads/c-api/
  10. This will be fixed in 10.4 Update 1.
  11. https://quality.embarcadero.com/browse/RSP-28886 try to run: sudo apt-get install curl
  12. Dmitry Arefiev

    Revisiting TThreadedQueue and TMonitor

    Thanks a lot ! The proposed here changes will be in 10.4 Update 1 with some modifications. Mostly due to new cross-platform AtomicCmpExchange128 for 64bit platforms.
  13. This is known issue: https://quality.embarcadero.com/browse/RSP-19708
  14. Dmitry Arefiev

    FireDac MySQL Connectivity

    1. libmysql.dll must be in EXE folder, or in some folder which is in PATH, or in SysWOW64 for x86 and System for x64. 2. libmysql.dll must have the same bitness as EXE. Simple way to verify it: tdump libmysql.dll | find "CPU type" 3. libmysql.dll v 8 is not yet supported. Use version 5 or 6. Which one - almost not important. 4. Note, that libmysql.dll, depending on version, depends on MS C RTL.
  15. You can try to do: FDUpdateSQL1.Commands[arInsert].CommandKind := skSelect;
  16. Dmitry Arefiev

    Why upgrade?

    Could you please provide RSP numbers. May be even you can provide your patch.
  17. Dmitry Arefiev

    FireDAC and read table metadata

    FDMetaInfoQuery1.MetaInfoKind := mkResultSetFields; FDMetaInfoQuery1.ObjectName := 'RESOURCE'; FDMetaInfoQuery1.Open;
  18. Dmitry Arefiev

    Why upgrade?

    Beside what @Vandrovnik said, Delphi with each one new version is getting more and more "green" (in the sense of Greenpeace, or energy class). What in past consumed N CPU cycles, now may consume less or much less. Want to make the World more green ? Upgrade your Delphi 🙂 PS: Of course, this is questionable statement. But it is true in many Delphi areas ...
  19. Dmitry Arefiev

    GetLastAutoGenValue

    For SQL Server the AName parameter usage is not specified.
  20. This is because ODBC 17 is unknown version for FireDAC.
  21. Dmitry Arefiev

    How to Code SQL IN Statement correctly

    For unlimited number of items for "IN" clause, may be possible to use SQL Server Table Valued Parameter. For details see "Object Pascal\Database\FireDAC\Samples\DBMS Specific\MSSQL\TVP" demo. PS: I am not tested that ...
  22. Dmitry Arefiev

    TFDBatchMoveSQLWriter and table structure updates

    TFDBatchMoveSQLWriter cannot alter table structure, it can only create a new table.
  23. Dmitry Arefiev

    THTTPReqResp.OnBeforePost breaking change

    @A.M. Hoornweg, did you checked THttpClient API ? accept gzip encoded data: set THttpClient.AutomaticDecompression to [THTTPCompressionMethod.GZip] accept an invalid/self-signed SSL certificate: set THttpClient.OnValidateServerCertificate to event handler which optionally can analyze Certificate and set Accepted to True / False
  24. @Edson.pol, could you please provide a test application, reproducing the issue. Also, do you have any non default settings in FetchOptions or ResourceOptions ?
  25. Dmitry Arefiev

    FDQuery, threads and CmdExecMode

    Leave it amBlocking.
×