-
Content Count
98 -
Joined
-
Last visited
-
Days Won
3
Dmitry Arefiev last won the day on February 20
Dmitry Arefiev had the most liked content!
Community Reputation
59 ExcellentTechnical Information
-
Delphi-Version
Delphi 10.4 Sydney
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
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
-
Firedac FDBatchMove.Execute error when last line in double-quote CSV file does not contain linefeed
Dmitry Arefiev replied to egnew's topic in Databases
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- 5 replies
-
- firedac
- fdbatchmove
-
(and 1 more)
Tagged with:
-
http://docwiki.embarcadero.com/Libraries/Sydney/en/FireDAC.Stan.Option.TFDFormatOptions.InlineDataSize
- 2 replies
-
- tfdmemtable
- ftstring
-
(and 2 more)
Tagged with:
-
TFDMemTable.CopyDataSet multiplicates some records
Dmitry Arefiev replied to Shavkat PANDA's topic in Databases
Fixed. Changes will be in 10.4 Update 2. -
TFDMemTable.CopyDataSet multiplicates some records
Dmitry Arefiev replied to Shavkat PANDA's topic in Databases
Yes, please. -
TFDMemTable.CopyDataSet multiplicates some records
Dmitry Arefiev replied to Shavkat PANDA's topic in Databases
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 -
TFDMemTable.CopyDataSet multiplicates some records
Dmitry Arefiev replied to Shavkat PANDA's topic in Databases
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 -
1) Please post FireDAC environment report for your connection: http://docwiki.embarcadero.com/RADStudio/Sydney/en/DBMS_Environment_Reports_(FireDAC)#Using_the_TFDConnection_Design_Time_Editor 2) Can you attach one of the DB files ?
-
Ole DB (Ado) for MSSQL un-deprecated by Microsoft
Dmitry Arefiev replied to A.M. Hoornweg's topic in Databases
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 ... -
Attach tFDmemTables to memory sqlite database
Dmitry Arefiev replied to dkounal's topic in Databases
http://docwiki.embarcadero.com/RADStudio/Sydney/en/Local_SQL_(FireDAC)- 3 replies
-
- sqlite
- tfdmemtable
-
(and 1 more)
Tagged with:
-
Adding lookup fields to active dataset, how?
Dmitry Arefiev replied to Jacek Laskowski's topic in Databases
No way. -
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)
-
You mean, that each FDQuery will get own connection from pool ? If yes, then this will lead to a lot of issues ...
-
When FDQuery's use ConnectionName, then single temporary TFDConnection will be created transparently and used by all FDQuery's, etc
-
Migration from BDE paradox to TFDtable or other options
Dmitry Arefiev replied to Javier Tarí's topic in Databases
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.