What is the difference between the TSQLDataSet, TSQLQuery, TSQLTable, and TSQLSimpleDataSet components?

10

In Delphi, following the line of the TTable and TQuery components in the component palette BDE we also have similar components in the dbExpress palette which are TSQLQuery and TSQLTable , and we still have the components TSQLDataSet and TSQLSimpleDataSet .

I see for example that TSQLSimpleDataSet incorporates properties and methods such as ClientDataSet , CreateDataSet , Data and Delta , as an example. Certainly such components exist because a specific purpose exists for each of them and can not all simply have the same purpose.

I think this is a basic foundation but of great importance to Delphi programmers

Then: What's the difference between these components? A practical application would be interesting!
To be clear, I am asking about each component mentioned. Not by the palette BDE or dbExpress .

    
asked by anonymous 23.04.2014 / 05:00

2 answers

6

What is the reason for TSimpleDataSet?

The TSQLQuery + TDataSetProvider + TClientDataSet set has many features and is widely used but there are cases of client server applications where the developer wants to use something simpler, something like a TSimpleDataSet that is actually the above-mentioned set embedded in a single component.

What about TSQLQuery and TSQLDataSet?

As can be seen in this link , Bruno Lichot (who was once an Embarcadero evangelist in Brazil) explains that TSQLQuery was mandated for compatibility and that TSQLDataSet is its evolution, doing the same things but having more features. Both are database query objects.

What about TSQLTable?

It is a simpler database query tool, which does not make personal queries in the database, just loading the contents of a table, something like a 'SELECT * FROM table'

    
23.04.2014 / 14:03
3

The Borland DataBase Engine was used.

Borland DataBase Engine in earlier versions of Delphi. While it is not obsolete ( yet?! ), it is advisable to migrate to dbExpress or FireDac .

The dbExpress was introduced from the 6 of Delphi to replace the BDE .

Currently the FireDAC if I'm not mistaken is available from XE3 ) came up to replace the dbExpress . FireDAC is undoubtedly a better solution, it is certainly worth migrating your applications from BDE or dbExpress to FireDAC >.

This article comments on something that should be of interest to you.

    
23.04.2014 / 06:53