Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!
Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Tek-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...I am very happy with the whole site and would like to extend my compliments to all of you who work to make it one of the most useful sites (If not THE Most Useful) ...and the easiest to navigate..."
More...

Geography

Where in the world do Tek-Tips members come from?
Click Here To Find Out!

Tek-Tips Shirts!

Get Tek-Tips Swag
Get your
Tek-Tips Forums
SWAG here!
Home > Forums > Programmers > Development Tools > Embarcadero: Delphi > FAQs

Embarcadero: Delphi FAQ

dbExpress

What are the main dbExpress components?
faq102-4717
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
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