Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

What are the main dbExpress components?

dbExpress

What are the main dbExpress components?

by  towerbase  Posted    (Edited  )
The two main dbExpress components are TSQLConnection and TSQLDataset.

TSQLConnection provides the mechanism to connect to (and disconnect from) a database. Drop the TSQLConnection components on your form and double click to open a dialog box where you can specify details of the database and the means to connect to it.

You can also use the TSQLConnection component to send SQL statements to the database providing they do not return a result set. Typically, these SQL statements would be CREATE, DROP and so on.

TSQLDataset provides the means to send SQL statements to the database which do return a result set. Typically, these are SELECT statements. An important consideration is that the returned result set is unidirectional.

There are other dbExpress components. These are TSQLTable, TSQLStoredProc, TSQLQuery and TSQLSimpleDataset. The first three provide some kind of compatibility with TTable, TStoredProc and TQuery to assist conversion from a BDE application. They are not intended to be used in new applications.
Register to add this FAQ to your archive
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top