Jump to content

Dmitry Arefiev

  • Content Count

  • Joined

  • Last visited

  • Days Won


Dmitry Arefiev last won the day on February 20 2021

Dmitry Arefiev had the most liked content!

Community Reputation

82 Excellent


Technical Information

  • Delphi-Version
    Delphi 11 Alexandria

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Dmitry Arefiev

    FDquery LoadfromFile

  2. Dmitry Arefiev

    DBGrid sort descending on Column Title Click

    ':D' is not supported by TClientDataSet ...
  3. Dmitry Arefiev

    TFDLocalSQL updates and TFDMemTable with calculated fields

    Could you please report this on https://quality.embarcadero.com. Then I will investigate. Thanks and regards, Dmitry
  4. Dmitry Arefiev

    FireDAC calling sp_pkeys

  5. Dmitry Arefiev

    2022 Stack Overflow Developer Survey

    Latest Firefox / Win7 (clean cache, disable plugins, what ever ...) - does not work Safari / macOS - works well Done.
  6. Dmitry Arefiev

    2022 Stack Overflow Developer Survey

    Not doable for me ... After clicking on the link I see the running circle forever ...
  7. Dmitry Arefiev

    Connect to MySQL on MacOS 64-Bit

    Did you use the steps from below ? https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Connect_to_MySQL_Server_(FireDAC)
  8. Dmitry Arefiev

    Connect to MySQL on MacOS 64-Bit

    Go to https://downloads.mysql.com/archives/c-c/, select macOS, etc, download archive, extract lib\libmysqlclient.18.dylib
  9. Dmitry Arefiev

    Syntax error in From clause

    > 1 FDWaitxxxx > 1 FDPHYSxxxFB (firebird) Long time are not required ...
  10. I saw this post in German Delphi-Praxis: https://www.delphipraxis.net/209869-firedac-moeglichkeit-die-abfrage-schneller-zu-machen-delphi.html So, anybody, who have account on both forums can answer there ... "Normally" constants vs parameters slowness is due to bad query execution plan when the parameters are in use. For example, Oracle (and not only) will stop to use indexes, when a parameter data type is not the same as a field one in a WHERE clause. This is because a type conversion is required, even if it looks "obvious". For example, a field is VARCHAR2 and a parameter is defined as ftWideString (eg, assigning it using Value / AsWideString instead of AsAnsiString). There are more examples ... From Oracle doc (https://docs.oracle.com/cd/B19306_01/server.102/b14211/ex_plan.htm#i3305): PS: As always, a Delphi version will be good to know ...
  11. Dmitry Arefiev

    Using TFDEventAlerter with MSSQL server

    Did you read and fully follow to the comment at: <demos>\Object Pascal\Database\FireDAC\Samples\DBMS Specific\MSSQL\QueryNotify\Unit1.pas Most of these are SQL Server "limitations" / "requirements".
  12. Dmitry Arefiev

    TFDMemTable & TSQLTimeStampOffsetField

    At moment ftTimeStampOffset is not supported by FireDAC
  13. Dmitry Arefiev

    Delphi/FireDAC and Firebird 4

    For Update: INT128 NUMERIC with precision 19..38 TIME WITH TIME ZONE, TIMESTAMP WITH TIME ZONE (limited) DECFLOAT(16/34) native statement timeout More later, because all other will be "interface breaking changes". So, not for Update.
  14. Dmitry Arefiev

    Delphi/FireDAC and Firebird 4

    Delphi 11 Update 1 will support Firebird 4.
  15. Dmitry Arefiev

    Delphi 11 TRestRequest Failure

    Why you dont want to change the REST.Client.pas unit ?