-
Content Count
174 -
Joined
-
Last visited
-
Days Won
4
Everything posted by Dmitry Arefiev
-
2022 Stack Overflow Developer Survey
Dmitry Arefiev replied to Darian Miller's topic in Tips / Blogs / Tutorials / Videos
Not doable for me ... After clicking on the link I see the running circle forever ... -
Did you use the steps from below ? https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Connect_to_MySQL_Server_(FireDAC)
-
Go to https://downloads.mysql.com/archives/c-c/, select macOS, etc, download archive, extract lib\libmysqlclient.18.dylib
-
> 1 FDWaitxxxx > 1 FDPHYSxxxFB (firebird) Long time are not required ...
-
RE: FireDAC: Möglichkeit die Abfrage schneller zu machen? ( in Delphi)
Dmitry Arefiev posted a topic in Databases
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 ... -
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".
-
TFDMemTable & TSQLTimeStampOffsetField
Dmitry Arefiev replied to MathiasBurbach's topic in Databases
At moment ftTimeStampOffset is not supported by FireDAC -
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.
-
Delphi 11 Update 1 will support Firebird 4.
-
Why you dont want to change the REST.Client.pas unit ?
-
There are posted workarounds: https://quality.embarcadero.com/browse/RSP-35365
-
Delphi 11 Windows XP compatibility tweak
Dmitry Arefiev replied to mitzi's topic in RTL and Delphi Object Pascal
TThread.IsTimeout -
Delphi 11 Windows XP compatibility tweak
Dmitry Arefiev replied to mitzi's topic in RTL and Delphi Object Pascal
Not at all. -
Delphi 11 Windows XP compatibility tweak
Dmitry Arefiev replied to mitzi's topic in RTL and Delphi Object Pascal
Please report this at quality.embarcadero.com -
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.