🚀 go-pugleaf

Hello Sky...

A TDataSet object MUST be in edit mode (either by having their AutoEdit
property set to true or by having their Edit() method called) before the
current record can have its field values changed. The changes to the current
record are not actually posted to the database until you go to another
record or explicitly call the Post() method of the dataset. If you wish to
cache changes to multiple records, you should look at setting the dataset's
CachedUpdate property to true (if your database engine supports this) or,
better still, use a TClientDataSet object

HTH...

Regards,

    Alex.

"Sky" <akeehuang@163.net> wrote in message
news:3e758449@newsgroups.borland.com...
> I am using ADO to operate database,
> TADOConnection/TADOQuery/TDataSource/TDBEdit has been used,
> if I set the AutoEdit property of TDataSource true,
> I can use it normally, the data in TDBEdit can save automatically.
> But if i set AutoEdit property false(I want save record manually till all
> data input completely),
> But It always raise exception class EDatabaseError when i modify the data
> and change the focus of active control, it show "DataSet not in edit or
> insert mode,
> I try to use the OnDatachange and OnUpdataData event of TDataSource
> or the OnEditError and BeforeEdit event of TADOQuery to verify this,
> But it always throw this exception first before these event had been
> triggered.
>
> Sky
>
>
>