INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
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
- 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.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
"...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..."
Where in the world do Tek-Tips members come from?
What are the main dbExpress components?
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
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:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close