TFDLocalSQL and TVirtualQuery

TFDLocalSQL and TVirtualQuery

Postby ccy » Fri 10 Nov 2017 14:25

TFDLocalSQL seems to work similarly as TVirtualQuery. Is there any advantage using TVirtualQuery over TFDLocalSQL?
Posts: 9
Joined: Tue 04 Oct 2005 03:39

Re: TFDLocalSQL and TVirtualQuery

Postby MaximG » Tue 14 Nov 2017 07:50

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
Devart Team
Posts: 787
Joined: Mon 06 Jul 2015 11:34

Return to VirtualDAC