Jump to content

Dmitry Arefiev

Members
  • Content Count

    174
  • Joined

  • Last visited

  • Days Won

    4

Everything posted by Dmitry Arefiev

  1. Dmitry Arefiev

    2022 Stack Overflow Developer Survey

    Not doable for me ... After clicking on the link I see the running circle forever ...
  2. 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)
  3. 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
  4. Dmitry Arefiev

    Syntax error in From clause

    > 1 FDWaitxxxx > 1 FDPHYSxxxFB (firebird) Long time are not required ...
  5. 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 ...
  6. 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".
  7. Dmitry Arefiev

    TFDMemTable & TSQLTimeStampOffsetField

    At moment ftTimeStampOffset is not supported by FireDAC
  8. 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.
  9. Dmitry Arefiev

    Delphi/FireDAC and Firebird 4

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

    Delphi 11 TRestRequest Failure

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

    Delphi 11 TRestRequest Failure

    There are posted workarounds: https://quality.embarcadero.com/browse/RSP-35365
  12. Please report this at quality.embarcadero.com
  13. Dmitry Arefiev

    StrToDate cannot handle dd-MMM-yy format

    Exactly, at first taking into account the support for "Arbitrary formats".
  14. Dmitry Arefiev

    StrToDate cannot handle dd-MMM-yy format

    But this also leads to incompatibility[ies], eg: https://quality.embarcadero.com/browse/RSP-35349
  15. Dmitry Arefiev

    StrToDate cannot handle dd-MMM-yy format

    Arbitrary formats - are also supported in v 11. Timezeone-aware datetimes - there is no such report in quality.embarcadero.com
  16. Dmitry Arefiev

    StrToDate cannot handle dd-MMM-yy format

    StrToDate in v11 supports MMM in date formats.
  17. Dmitry Arefiev

    FireDAC with multiple SQL

    You can find several answers on top: https://www.google.com/search?q=postgresql+anonymous+block+parameters
  18. Request must contain valid Accept header, then RAD Server will choose the correct endpoint. If there is no Accept, or it is not unique identifying endpoint, then above error is returned. Check what your browser is sending in request Accept headers.
  19. try var LURI := TURI.Create(AURI); Result := True; except Result := False; end;
  20. Dmitry Arefiev

    Firedac Indexes Distinct

    Please report that to quality.embarcadero.com and provide simple test application to reproduce the issue. Without details / code hard to say anything ...
  21. Dmitry Arefiev

    Firedac and MariaDB

    http://docwiki.embarcadero.com/RADStudio/Sydney/en/Configuring_Drivers_(FireDAC)
  22. Dmitry Arefiev

    FireDac Batchmove

    @bazzer747, if you think there is an issue, please post your report to quality.embarcadero.com. And attach to your issue: FireDAC environment report - http://docwiki.embarcadero.com/RADStudio/Sydney/en/DBMS_Environment_Reports_(FireDAC)#Using_Delphi_Code small test application reproducing the issue. PS: It should work ...
  23. You should understand what all these redirections are: if this is endless loop of redirections, then many options: fix the server logic; use different URL; provide additional headers (eg authentication); etc if this is long chain of redirections, then set MaxRedirects to a higher value.
×