Fernando Rizzato
A customer recently asked me if FireDAC can be used to connect to a database through an SSH tunnel. The short answer is yes, of course. But let’s understand better what is an SSH tunnel,… … Read more
5 years ago in database , Delphi , firedac , News , SSH 0
Konstantin Tomov
The Commands sample shows you how to set up column mappings. Location You can find the MappingColumns sample project at: Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to: Object PascalDatabaseFireDACSamplesDApt LayerMappingColumns Subversion Repository: You… … Read more
5 years ago in Code , Columns , database , dataset , Delphi , firedac , ios , linux , macos , Mapping , object pascal , programming , RAD Studio , Sample , windows 0
Muminjon
Most of the time, developers tend to use DataSet to manipulate the data in their applications. DataSet is helpful because it stores data in the dataset’s fields array property. You can easily access these values… … Read more
5 years ago in android , Code , dataset , dataset to json , Delphi , firedac , ios , JSON , json to dataset , linux , macos , object pascal , programming 0
Konstantin Tomov
The sample also admits authentication. Apart from the parameters to connect to an InterBase server, the sample has four tabs to perform administrative tasks: Server Users Tab: Click Refresh Users to get all the users from the InterBase… … Read more
5 years ago in adminutility , Code , database , Delphi , firedac , InterBase , object pascal , programming , RAD Studio , windows 0
Konstantin Tomov
This sample project demonstrates how to migrate the project MeetingOrganizer from dbExpress to FireDAC using the reFind.exe tool. Location You can find the DBX2FDMigration project at: Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:… … Read more
5 years ago in C++ , Code , database , dbExpress , dbx , Delphi , firedac , Migration , object pascal , programming , RAD Studio , windows 0
Konstantin Tomov
Escape sequences allow for writing DBMS-independent SQL commands. The sample predefines some escape function sequences. To execute a predefined escape function, right-click the Function edit box and choose a predefined escape function from the popup menu. Moreover, the… … Read more
5 years ago in Code , database , Delphi , escape , escape sequence , EscapeFunction , firedac , function , object pascal , programming , RAD Studio , windows 0
Konstantin Tomov
FireDAC.SchemaAdapterMemTable … Read more
5 years ago in adapter , android , Code , cross-platform , database , Delphi , firedac , ios , linux , macos , object pascal , programming , RAD Studio , schema , tables , windows 0
Konstantin Tomov
The CachedUpdates sample shows you how to work with the TFDMemTable class. To this end, TFDMemTable retrieves data from a database through TFDTableAdapter and TFDCommand. Then, the sample uses some methods and properties of TFDTableAdapter in order to implement some features related with the management of Cached… … Read more
5 years ago in CachedUpdates , Code , database , Delphi , firedac , ios , linux , macos , object pascal , programming , RAD Studio , tfdmemtable , windows 0
Embarcadero Admin
Robo-Analyst is a powerful financial software that gives an instant analysis on more than 16,000 stocks, funds, and cryptocurrencies and it is built with Delphi. According to Robo-Analyst their advanced software analyzes and interprets the… … Read more
5 years ago in amazon , crypto , cryptocurrency , Delphi , equity , financial , firedac , google , object pascal , programming , rad server , robo-analyst , Showcase , stock , WebBroker 0
Konstantin Tomov
The sample uses the IFDPhysCommand interace to fetch rows from the current command cursor in the DatS table. To this end, the sample creates a command interface to: Prepare a SELECT command. Define the structure of the DatS table. Open the command interface. Fetch the table. Print the fetched rows Location… … Read more
5 years ago in android , Code , database , Delphi , FetchTables , firedac , ifpdphyscommand , ios , linux , macos , object pascal , programming , RAD Studio 0
Konstantin Tomov
This sample demonstrates how to define the client-side aggregating formulas with TFDQuery. You can find out more about aggregated fields and values in the Embarcadero DocWiki. The fkAggregate aggregated fields management is similar to the expression calculated fields… … Read more
5 years ago in aggregates , Code , database , Delphi , firedac , ios , linux , macos , object pascal , programming , Query , RAD Studio , Tfdquery , windows 0
Konstantin Tomov
This sample demonstrates two ways of handling errors in an array DML execution. To this end, the sample implements two ways of handling the errors: Implementing an OnError event. Using the EFDDBEngineException class on a loop. Location You can find the BatchErrorHandling sample project… … Read more
5 years ago in android , array dml , batch , Code , Delphi , error handling , firedac , ios , linux , macos , object pascal , programming , Query , RAD Studio , windows 0
Konstantin Tomov
The OnUpdateRecord sample shows you how to cache the user changes when using read-only dataset and then, how to apply updates on behalf of queries that cannot post updates directly. To this end, the sample uses the OnUpdateRecord event… … Read more
5 years ago in android , Delphi , firedac , ios , linux , macos , object pascal , onupdate , programming , RAD Studio , Tfdquery , Update , update record , windows 0
Konstantin Tomov
The sample shows in a nice way how to use the TFDLocalSQL component to execute SQL commands on in-memory database, represented by several TFDMemTables. This sample uses a TFDConnection to connect to the SQLite in-memory database (with empty Database parameter value)…. … Read more
5 years ago in android , Code , database , dataset , Delphi , firedac , ios , linux , localsql , macos , object pascal , programming , RAD Studio , SQL , tfdmemtable , windows 0
VOTE
Thushara Wedagedara
What is ETL? You may come from another programing language or you might have started a new business and want to gather data to include in your new software system. Or perhaps you might want… … Read more
5 years ago in Delphi, ETL, firedac, LiveBindings, News, REST, SOAP
0