🚀 go-pugleaf

Jackie,

I 'feel' what you mean.

IMHO a DBGrid is not always that user-friendly as it may appear. An
inexperienced user may change lots of records with some mouseclicks or
keypresses without even noticing it.

In most of my database apps I set a 'physical' border between browsing and
editing. While browsing, the db-aware controls are disabled (TDBEdit) or
readonly (TDBGrid). If the user wants to edit the record he/she has to press
a button named "Change Record". In addition I prefer to use different
colours for different actions. For example a green background while browsing
and a red background while editing.

Doing this it could be much clearer to the user what he/she is actually
doing.

--
HTH

Ronald Loonstra
CodeFit Applications
www.codefit.nl

"Jackie" <tkfi@hotmail.com> schreef in bericht news:3d4767ba$1_1@dnews...
> Hi Ronald
> Thank for your helping
>
> if set the AutoEdit to false it will have a throw exception when editing
the
> DBEdit
> dose it have something call Auto commit and can be set to false.
>
> the idea is when a user browsing a list of record through the DBGrid, and
if
> he carelessly put the keyboard without any noetic, and he still go on to
> browse the record, this will cause the wrong record. i just want to avoid
> that.
>
> Thanks a lot
>
> "Ronald Loonstra" <r.loonstra@codefit.nl> ���g��l��
> news:3d475762$1_1@dnews...
> > Set the AutoEdit-property of the TDataSource to false.
> >
> > Maybe this helps.
> > --
> > HTH
> >
> > Ronald Loonstra
> > CodeFit Applications
> > www.codefit.nl
> >
> > "Jackie" <tkfi@hotmail.com> schreef in bericht
news:3d472b9d$1_1@dnews...
> > > Dear All
> > >
> > > let say i have a ADOConnection ADOQuery DataSource DBGrid and some
> DBEdit
> > ,
> > > all are connect to a MS-Access database, every thing is working , but
> > there
> > > has a problem, where the ADOQuery is active, the DBGrid list all
record
> on
> > a
> > > table and the DBEdit display one of the record that i have select , in
> > this
> > > time if i input something on the DBEdit , and move the pointer to the
> next
> > > record or use mouse click on other record in the DBGrid, the previous
> > record
> > > (that i have input something on) will than be change, if i don't want
to
> > > change the record ( but i already input something on the some
DBEdit ),
> i
> > > have to call "ADOQuery->Cancel" to cancel the change before i move the
> > > pointer, how i set the DBEdit can be accessable (can input not read
> only)
> > > but won't change the record after i move the pointer.
> > >
> > > Please help
> > > Thank a lot
> > >
> > >
> >
> >
>
>