Jump to content

Dmitry Arefiev

  • Content Count

  • Joined

  • Last visited

  • Days Won


Dmitry Arefiev last won the day on February 20

Dmitry Arefiev had the most liked content!

Community Reputation

63 Excellent


Technical Information

  • Delphi-Version
    Delphi 10.4 Sydney

Recent Profile Visitors

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

  1. Dmitry Arefiev

    FireDAC with multiple SQL

    You can find several answers on top: https://www.google.com/search?q=postgresql+anonymous+block+parameters
  2. 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.
  3. try var LURI := TURI.Create(AURI); Result := True; except Result := False; end;
  4. 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 ...
  5. Dmitry Arefiev

    Firedac and MariaDB

  6. 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 ...
  7. 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.
  8. Dmitry Arefiev

    TNumberBox suffix?

    VCL or FMX ? If VCL, then: NumberBox1.Mode := nbmCurrency; NumberBox1.Decimal := 0; NumberBox1.CurrencyString := 'pixel'; NumberBox1.CurrencyFormat := 3; // etc, eg MinValue=0, MaxValue=1500
  9. Dmitry Arefiev

    SQLite, adding a function

    SQLite is really typeless database. When you use AOutput.AsCurrency, then FireDAC maps this to SQLITE_TEXT (to keep precision), and AOutput.AsFloat to SQLITE_FLOAT. To "remap" an expression in SELECT list to a Delphi specific type you should use special construction in SELECT list: <expression> AS "<alias>::<type>" More about that: http://docwiki.embarcadero.com/RADStudio/Sydney/en/Using_SQLite_with_FireDAC#Adjusting_FireDAC_Mapping
  10. This is a bug in TFDBatchMoveTextReader. To fix it: open FireDAC.Comp.BatchMove.Text.pas locate there lines (around line # 1750): until FEof or lEOL or not lInDelim and (FBuff[iLen] = DataDef.Separator); if not FEof then Dec(iLen); replace with: until FEof or lEOL or not lInDelim and (FBuff[iLen] = DataDef.Separator); if not FEof or not lEOL then Dec(iLen); add FireDAC.Comp.BatchMove.Text.pas to your project, or include path to this unit to project->options Search Path, or to tools->options Library Path PS: Best will be to report this issue to quality.embarcadero.com
  11. Dmitry Arefiev

    ftstring vs varchar in TFDMemTable

  12. Dmitry Arefiev

    TFDMemTable.CopyDataSet multiplicates some records

    Fixed. Changes will be in 10.4 Update 2.
  13. Dmitry Arefiev

    TFDMemTable.CopyDataSet multiplicates some records

    Ok, I reproduced your issue after modifing your failing query in second post to: select * from FDMemTable1 where Field_1 like :Param_B or Field_2 like :Param_B or Field_3 like :Param_B
  14. Dmitry Arefiev

    TFDMemTable.CopyDataSet multiplicates some records

    I cannot reproduce the issue using 10.4.1. Could you please post: 1) Your RAD Studio version 2) Simple test project reproducing the issue