🚀 go-pugleaf

Thanks for you help, But I want to know how to catch the error
if the AutoEdit property set false or Edit() method is not been called.
It always show "DataSet not in edit or insert mode",
I want catch this error and cancel rejigger. Any hint? TIA

Sky


"Alex Ip" <alex.ip@bigpond.com> wrote in message
news:3e7956dc$1@newsgroups.borland.com...
> 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
> >
> >
> >
>
>