[ Thanks for this link to Bob Swart, who adds: “Kylix is the
codename of the Linux edition of Borland Delphi and C++Builder. For
more information on Kylix, see Dr.Bob’s Kylix Kicks website.”
]
“dbExpress is capable of processing queries and stored
procedures like the BDE (Borland Database Engine). BDE is a feature
rich, bulkier client whereas dbExpress is simpler, easy to
implement and best suits the MIDAS provider and resolver
model.”
“Database intensive applications should use queries or stored
procedures to get to the data. Opening table through BDE not only
consumes client resources but also locks up server resources.
dbExpress eliminates the concept of opening tables, and clients are
recommended to use SQL queries with better selectivity for
optimized data-access.”
“A statement handle for a connection must be allocated before
any SQL statement can be processed. Most databases allow you to
have more than one active statement per connection. On servers that
don’t, you may have to establish a separate connection to process
multiple SQL statements simultaneously. You can also set and get
statement level properties with a statement handle.”