Jump to content

Dmitry Arefiev

Members
  • Content Count

    90
  • Joined

  • Last visited

  • Days Won

    2

Dmitry Arefiev last won the day on June 2

Dmitry Arefiev had the most liked content!

Community Reputation

51 Excellent

4 Followers

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

    Ole DB (Ado) for MSSQL un-deprecated by Microsoft

    In the plan is to check latest MS SQL ODBC driver, and update FireDAC MSSQL driver if needed. No plans for OLEDB support. Just no sense ...
  2. Dmitry Arefiev

    Attach tFDmemTables to memory sqlite database

    http://docwiki.embarcadero.com/RADStudio/Sydney/en/Local_SQL_(FireDAC)
  3. Dmitry Arefiev

    Adding lookup fields to active dataset, how?

    No way.
  4. Dmitry Arefiev

    IIF func in FireDAC SQLite Local SQL

    FireDAC in 10.4.1 uses SQLite 3.31.1. But IIF was added in 3.32. Instead you can use FireDAC macro function: {IIF(....)}: http://docwiki.embarcadero.com/RADStudio/Sydney/en/System_Macro_Functions_(FireDAC)
  5. Dmitry Arefiev

    FireDAC and pooling random error

    You mean, that each FDQuery will get own connection from pool ? If yes, then this will lead to a lot of issues ...
  6. Dmitry Arefiev

    FireDAC and pooling random error

    When FDQuery's use ConnectionName, then single temporary TFDConnection will be created transparently and used by all FDQuery's, etc
  7. Dmitry Arefiev

    Migration from BDE paradox to TFDtable or other options

    FireDAC TFDTable emulates BDE/Paradox TTable behavior using LDW mode. This is expensive, and disabling LDW mode will improve performance. More info: http://docwiki.embarcadero.com/RADStudio/Sydney/en/Browsing_Tables_(FireDAC) But anyway, you will never get 100% similar performance to BDE/Paradox TTable with big tables. Any TxxxTable will request DB server and will fetch the data. When data is fetched, then operations will be fast and similar to TTable.
  8. Dmitry Arefiev

    Problems changing database with pooled connection

    Yes, it is. But you can use always full object (table) name.
  9. Dmitry Arefiev

    Problems changing database with pooled connection

    Other option is to use TFDManager.CloseConnectionDef http://docwiki.embarcadero.com/RADStudio/Sydney/en/Multithreading_(FireDAC)#Connection_Pooling
  10. Dmitry Arefiev

    Problems changing database with pooled connection

    FDManager.Active := False; // change what you need
  11. Dmitry Arefiev

    TFDQuery - Query all databases on a server

    Q3 at http://docwiki.embarcadero.com/RADStudio/Sydney/en/TFDQuery,_TFDStoredProc_and_TFDUpdateSQL_Questions
  12. 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.
  13. Dmitry Arefiev

    Firedac - Sqlite - DateTime field

    Sorry for spamming, dont know how it happened ...
  14. 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
  15. 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
×