TFDLocalSQL and TVirtualQuery
Posted: Fri 10 Nov 2017 14:25
TFDLocalSQL seems to work similarly as TVirtualQuery. Is there any advantage using TVirtualQuery over TFDLocalSQL?
Among the distinguishing features of TVirtualQuery are the following:
a) TVirtualQuery is TDataSet descendant, that allows using it directly with all visual DB-Aware components
b) TVirtualQuery does not require additional components for its work (Connections, DriverLinks, etc.)
c) TVirtualQuery supports DataTypeMapping - a special mechanism that allows the developer to flexibly create mappings between DB types and Delphi field types
d) TVirtualQuery allows you to create User Defined Functions, the application of which in SQL query significantly extends data processing capabilities