-
Content Count
160 -
Joined
-
Last visited
-
Days Won
4
Everything posted by Dmitry Arefiev
-
Firedac lost ftDate field type after using the SQLITE date() function
Dmitry Arefiev replied to Stéphane Wierzbicki's topic in Databases
http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Using_SQLite_with_FireDAC#Adjusting_FireDAC_Mapping Read sentence "For an expression in a SELECT list ..." -
A Curious Inheritance Problem... what pattern solves it?
Dmitry Arefiev replied to David Schwartz's topic in RTL and Delphi Object Pascal
Is it bad to use official DLL ? Several questions: * are you limited in distributing capabilities of this DLL (license, space, what ever) ? * who will support you, when something is broken, and you are using non-official connectivity ? * with whom you you can discuss your connectivity problems on INet, if you are using some from 3d party ? * how long will live your software, when 3d party provider is out of business, and DLL "insides"/protocol are changed ? -
A Curious Inheritance Problem... what pattern solves it?
Dmitry Arefiev replied to David Schwartz's topic in RTL and Delphi Object Pascal
This is IProviderSupport or IProviderSupportNG. -
Yes, it is.
- 5 replies
-
- firedac
- sql server
-
(and 1 more)
Tagged with:
-
This issue was (most probably) fixed in 10.2.2. Your workaround is almost correct.
- 5 replies
-
- firedac
- sql server
-
(and 1 more)
Tagged with:
-
A Curious Inheritance Problem... what pattern solves it?
Dmitry Arefiev replied to David Schwartz's topic in RTL and Delphi Object Pascal
You can do, when both conditions are met: * TOracleDataSet and TgQuery both are inherited from TDataSet * and properly implement IProviderSupport methods: procedure Form1.Proc1( aQry : TDataSet ); begin ... aQry.Close; (aQry as IProviderSupport).PSSetCommandText('select * from xyz'); aQry.Open; ... end; -
Check for override
Dmitry Arefiev replied to Jacek Laskowski's topic in RTL and Delphi Object Pascal
Could you please provide some tickets to better understand what and where. -
Datasnap REST Calls TDSRestProtocolException on Delphi 10.2.1 and above
Dmitry Arefiev replied to MikeMon's topic in Network, Cloud and Web
https://www.wireshark.org/ https://www.telerik.com/fiddler -
Datasnap REST Calls TDSRestProtocolException on Delphi 10.2.1 and above
Dmitry Arefiev replied to MikeMon's topic in Network, Cloud and Web
In this case I would try to capture HTTP packets sent from 10.1.2 and 10.2.1 clients. And will try to understand what is the difference between them, which may lead to this failure ... -
Datasnap REST Calls TDSRestProtocolException on Delphi 10.2.1 and above
Dmitry Arefiev replied to MikeMon's topic in Network, Cloud and Web
This is not related to REST client. But is related to REST server, which is accessing to InterBase server. And due to some reason the database specified in FireDAC connection parameters is not available. Start from checking your InterBase interbase.log ... -
Erro 10.3.1 java.lang.IllegalStateException
Dmitry Arefiev replied to Marcio's topic in Cross-platform
The patch and instruction is published there: https://quality.embarcadero.com/browse/RSP-23656 -
@RDPasqua, depends on RAD Studio version. In 10.3 standard JSON library is much faster and reliable.
-
This issue is fixed in 10.3 Rio. And more is comming in Updates. If to stay with 10.1, then search and install IDE HotFix Pack.
-
How to pass an unknown record to a function as argument
Dmitry Arefiev replied to John Kouraklis's topic in RTL and Delphi Object Pascal
GetValue (@Rec) -
SQLBindParameter error with TFDQuery / ODBC
Dmitry Arefiev replied to Nathan Wild's topic in Databases
https://quality.embarcadero.com/browse/RSP-20857 Will be fixed in 10.3 Update 1 -
Firedac and SQL Server DB with "." in name
Dmitry Arefiev replied to Martyn Spencer's topic in Databases
https://quality.embarcadero.com/browse/RSP-20349 -
Guessing the decimal separator
Dmitry Arefiev replied to dummzeuch's topic in Algorithms, Data Structures and Class Design
No sense, as in the trial to find 100% working guessing -
Guessing the decimal separator
Dmitry Arefiev replied to dummzeuch's topic in Algorithms, Data Structures and Class Design
It is impossible to decide for 100%. But possible to guess taking into account ThousandSeparator and DecimalSeparator. It will work in 95.38% of the cases. All other - up to the user. -
General DB access question -- paging query results
Dmitry Arefiev replied to David Schwartz's topic in Databases
Oracle 12 extended maximum length of VARCHAR2 to 32Kb. And there always was LONG. CLOB / BLOB are stored in tablespaces. BFILE are stored in external files. -
You need to use sslxxxx PostgreSQL connection parameters: https://www.postgresql.org/docs/11/libpq-connect.html#LIBPQ-PARAMKEYWORDS And put them into FireDAC PGAdvanced connection parameter: http://docwiki.embarcadero.com/RADStudio/Tokyo/en/Connect_to_PostgreSQL_(FireDAC)#Connection_Definition_Parameters
-
ISAPI in Delphi 10.2,10.3 TranslateURI
Dmitry Arefiev replied to hsvandrew's topic in Network, Cloud and Web
Instead of last "Size" reference there should be "Size - 1". Fixed. -
@ihx, please, report this issue to https://quality.embarcadero.com
-
1) This is worth to report, but rather as a feature request. Support for automatic decoding may be done easily using WinHTTP WINHTTP_OPTION_DECOMPRESSION option. And probably already in 10.3 Update 1. As a quick workaround, you can modify System.Net.HttpClient.Win.pas, for example: function TWinHTTPClient.DoExecuteRequest(const ARequest: THTTPRequest; var AResponse: THTTPResponse; const AContentStream: TStream): TWinHTTPClient.TExecutionResult; begin ..... // Enable automatic decoding LOptionValue := WINHTTP_DECOMPRESSION_FLAG_GZIP or WINHTTP_DECOMPRESSION_FLAG_DEFLATE or WINHTTP_DECOMPRESSION_FLAG_ALL; WinHttpSetOption(LRequest.FWRequest, WINHTTP_OPTION_DECOMPRESSION, @LOptionValue, sizeof(LOptionValue)); .... end; 2) THTTPReqResp was using WinINet API directly. In 10.3 it was completely reworked to enable support of other platforms, including Linux, OSX, etc.
-
Backup FB3 Embedded through TIBBackup component
Dmitry Arefiev replied to Andrea Magni's topic in Databases
Changing method to code below and setting FDPhysFBDriverLink1.Embedded to True will make it working. Without that the only workaround is to renamed fbclient.dll into fbembed.dll. procedure TIBLib.LoadFB(const AVendorHome, AVendorLib: String; AEmbedded, AThreadSafe: Boolean); {$IFNDEF FireDAC_IB_STATIC} const C_FBClient: String = {$IFDEF MSWINDOWS} 'fbclient' {$ENDIF} {$IFDEF POSIX} 'libfbclient' {$ENDIF} + C_FD_DLLExt; C_FBEmbed: String = {$IFDEF MSWINDOWS} 'fbembed' {$ENDIF} {$IFDEF POSIX} 'libfbembed' {$ENDIF} + C_FD_DLLExt; {$ENDIF} begin if AEmbedded then LoadBase(AVendorHome, AVendorLib, AThreadSafe {$IFNDEF FireDAC_IB_STATIC}, [C_FBEmbed, C_FBClient] {$ENDIF}) else LoadBase(AVendorHome, AVendorLib, AThreadSafe {$IFNDEF FireDAC_IB_STATIC}, [C_FBClient, C_FBEmbed] {$ENDIF}); if AEmbedded and (Version >= ivFB030000) then FEmbedded := True; end; -
Backup FB3 Embedded through TIBBackup component
Dmitry Arefiev replied to Andrea Magni's topic in Databases
This is something to report to quality.embarcadero.com ...