CodeDatabaseDelphiRAD Studio

Learn To Populate A String List With Some Data From A Database With The FireDAC.GetFieldNames Delphi Sample

By
October 6, 2020
To this end, the sample uses the following methods of theTFDConnectioncomponent: GetTableNamespopulates a string list with the names of tables in a database.GetFieldNamespopulates a string list with the names of fields in a table.GetKeyFieldNamespopulates a string list with the names of the key fields in a table. Location You can find…
Read more
DatabaseNews

5 Aqua Data Studio features for an Application Developer

By
October 2, 2020
Data has become one of the most important aspects to any company.  As databases evolve to support big(ger) data, highly available web applications, and deal with more complex levels of business logic, the applications that represent the user interface and business logic of this change have become more challenging. For many application developers, we don’t just write application code. We spend a…
Read more
C++

Secrets Of FireDAC: Dynamic Where Clause Using Conditional Substitution Macros

By
July 19, 2018
If you are using FireDAC and building your SQL queries manually you may be using more verbose code than is needed. FireDAC has a feature called Macros which allows you to do a variable substitution in your SQL query similar to parameter substitution but for raw SQL. However, in addition to macro substitution you can combine it with conditional substitutions which lets you do the real magic. If you…
Read more
News

10 Quick Tips & Tricks for SQL Server Developers

By
July 8, 2015
Author: Embarcadero USA Here are 10 quick SQL Server tips and tricks for database developers compiled by SQL Server expert Pinal Dave. For inefficient query plans: Check for issues with bad cardinality estimates. The maximum degree of parallelism can be limited server-wide by using the max degree of parallelism option. DMV – sys.dm_os_nodes provides information about CPU node…
Read more