CodeDelphiRAD Studio

Quickly Set Up Flexible Master-Detail Relationships Between Datasets In Delphi Apps

By
January 18, 2021
The sample uses the master-detail relationship to automatically filter a detail dataset based on a current master dataset record. In this sample, the master dataset has “Order” records, and the detail dataset shows only lines for the current order. Moreover, the sample uses theModeproperty ofTFDFetchOptionsto control how the result set records must be fetched…
Read more
CodeDatabaseDelphiRAD Studio

Power Tip: Learn How to Send Arrays To An InterBase Database Using FireDAC In Delphi

By
January 13, 2021
The Arrays sample shows you how to use the TFDParam.ArrayType property to send arrays to a database server. To this end the ArrayType property is set to atTable.Note: This demo establishes a connection to the Interbase localhost server by default, using the SYSDBA user. You can change these parameters to connect to a different InterBase server using a valid user name and…
Read more
CodeDatabaseDelphiRAD Studio

Learn How To Define Powerful Dataset Views Using Indices With FireDAC In Delphi Windows Development

By
January 11, 2021
The Indices sample shows you how to use the Indexes property of TFDQuery in order to specify a collection of indexes at design time and determine the data view of each index, including a sort order of the records. Moreover, you can sort the records on a specific field using the IndexFieldNames property. Click on a grid column title to sort its records at run time. Location You can…
Read more