-
Content Count
129 -
Joined
-
Last visited
-
Days Won
3
Dmitry Arefiev last won the day on February 20 2021
Dmitry Arefiev had the most liked content!
Community Reputation
82 ExcellentTechnical Information
-
Delphi-Version
Delphi 11 Alexandria
Recent Profile Visitors
The recent visitors block is disabled and is not being shown to other users.
-
https://docwiki.embarcadero.com/Libraries/Alexandria/en/FireDAC.Stan.Option.TFDBottomResourceOptions.PersistentFileName
-
DBGrid sort descending on Column Title Click
Dmitry Arefiev replied to ChrisChuah's topic in Databases
':D' is not supported by TClientDataSet ... -
TFDLocalSQL updates and TFDMemTable with calculated fields
Dmitry Arefiev replied to Brent Rose's topic in Databases
Could you please report this on https://quality.embarcadero.com. Then I will investigate. Thanks and regards, Dmitry- 1 reply
-
- firedac
- calculated fields
-
(and 1 more)
Tagged with:
-
https://docwiki.embarcadero.com/RADStudio/Alexandria/en/Unique_Identifying_Fields_(FireDAC)
-
2022 Stack Overflow Developer Survey
Dmitry Arefiev replied to Darian Miller's topic in Tips / Blogs / Tutorials / Videos
Latest Firefox / Win7 (clean cache, disable plugins, what ever ...) - does not work Safari / macOS - works well Done. -
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 ?