DatabaseNews

User Defined Functions with InterBase

InterBase has several built in functions that developers can use to create and optimize SQL queries. In some situations though, you may find yourself needing to expand queries or work with more complex queries that include string, date and statistical functions. InterBase’s way to resolve this problem is by supporting libraries or user defined functions or UDFs. UDFs are programs for performing…
Read more
CodeDatabaseDelphiRAD Studio

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

TheArrayssample shows you how to use theTFDParam.ArrayTypeproperty to send arrays to a database server. To this end theArrayTypeproperty is set toatTable.Note: This demo establishes a connection to the Interbase localhost server by default, using theSYSDBAuser. You can change these parameters to connect to a different InterBase server using a…
Read more
CodeDatabaseDelphiRAD Studio

Quickly Learn How To Debug And Monitor Your FireDAC Connection In Delphi

TheMoniLayerClientssample shows you how to use the FireDACtracing and monitoringcapabilities to show how an application is communicating with a FireDAC monitor client. To this end, the sample uses two different FireDAC monitor clients: FlatFile-client and Remote-client. To use both monitor clients, the sample uses two client link components: the TFDMoniFlatFileClientLink…
Read more