-
Content Count
160 -
Joined
-
Last visited
-
Days Won
4
Everything posted by Dmitry Arefiev
-
StrToDate cannot handle dd-MMM-yy format
Dmitry Arefiev replied to Dave Novo's topic in RTL and Delphi Object Pascal
Exactly, at first taking into account the support for "Arbitrary formats". -
StrToDate cannot handle dd-MMM-yy format
Dmitry Arefiev replied to Dave Novo's topic in RTL and Delphi Object Pascal
But this also leads to incompatibility[ies], eg: https://quality.embarcadero.com/browse/RSP-35349 -
StrToDate cannot handle dd-MMM-yy format
Dmitry Arefiev replied to Dave Novo's topic in RTL and Delphi Object Pascal
Arbitrary formats - are also supported in v 11. Timezeone-aware datetimes - there is no such report in quality.embarcadero.com -
StrToDate cannot handle dd-MMM-yy format
Dmitry Arefiev replied to Dave Novo's topic in RTL and Delphi Object Pascal
StrToDate in v11 supports MMM in date formats. -
You can find several answers on top: https://www.google.com/search?q=postgresql+anonymous+block+parameters
-
RAD Studio 10.4.2: RAD Server and “Duplicate enpoints” image or text
Dmitry Arefiev replied to Lorenzo Sampietro's topic in Network, Cloud and Web
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. -
Does Delphi have a counterpart for C#/.NET Uri.IsWellFormedUriString?
Dmitry Arefiev replied to wuwuxin's topic in RTL and Delphi Object Pascal
try var LURI := TURI.Create(AURI); Result := True; except Result := False; end; -
Please report that to quality.embarcadero.com and provide simple test application to reproduce the issue. Without details / code hard to say anything ...
-
http://docwiki.embarcadero.com/RADStudio/Sydney/en/Configuring_Drivers_(FireDAC)
-
@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 ...
-
Delphi 10.3 TNetHTTPClient Max redirects exceeded
Dmitry Arefiev replied to xorpas's topic in Network, Cloud and Web
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. -
VCL or FMX ? If VCL, then: NumberBox1.Mode := nbmCurrency; NumberBox1.Decimal := 0; NumberBox1.CurrencyString := 'pixel'; NumberBox1.CurrencyFormat := 3; // etc, eg MinValue=0, MaxValue=1500
-
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- 6 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 ...