TFDLocalSQL and TVirtualQuery
TFDLocalSQL and TVirtualQuery
TFDLocalSQL seems to work similarly as TVirtualQuery. Is there any advantage using TVirtualQuery over TFDLocalSQL?
Re: TFDLocalSQL and TVirtualQuery
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
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