TFDLocalSQL and TVirtualQuery

Discussion of open issues, suggestions and bugs regarding Virtual Data Access Components for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Posts: 9
Joined: Tue 04 Oct 2005 03:39

TFDLocalSQL and TVirtualQuery

Post by ccy » Fri 10 Nov 2017 14:25

TFDLocalSQL seems to work similarly as TVirtualQuery. Is there any advantage using TVirtualQuery over TFDLocalSQL?

Devart Team
Posts: 862
Joined: Mon 06 Jul 2015 11:34

Re: TFDLocalSQL and TVirtualQuery

Post by 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

Post Reply