INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

dbExpress

What are the main dbExpress components? by towerbase
Posted: 14 Jan 04

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.

Back to Embarcadero: Delphi FAQ Index
Back to Embarcadero: Delphi Forum

My Archive

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close