At 4/3/2001 05:49 PM (Tuesday), zepplin20001@... wrote:

>I don't know if I've missed something but it seems very unsatisfying
>the way vcl db controls act when we commit a transaction.

What you are seeing is the effect of how the BDE deals with databases, sort
of a watered down lowest common denominator approach. Most developers who
experience the frustration you have described end up switching to a
different middleware layer such as IBObjects or Direct Oracle Access
components. These eliminate the BDE layer and provide access to the more
sophisticated features of the database servers.

The VCL is somewhat to blame, although it has evolved to better abstract
its layers so that these alternative middleware products can almost
seamlessly integrate.