🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #3548

Re: Question about ADOQuery

#3548
From: Jackie
Date: Wed, 31 Jul 2002 10:05
111 lines
4050 bytes
Hi Ronald

Thank your advice , is very useful.

very appreciate that

"Ronald Loonstra" <r.loonstra@codefit.nl> ���g��l��
news:3d4770b3_1@dnews...
> 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
> > > >
> > > >
> > >
> > >
> >
> >
>
>
Technical Details
Message-ID: <3d47b6d8$1_1@dnews>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!colt.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!dnews
References: <3d472b9d$1_1@dnews> <3d475762$1_1@dnews> <3d4767ba$1_1@dnews> <3d4770b3_1@dnews>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,99b6fc4567ab9216
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-31 03:15:57 PST
From: "Jackie" <tkfi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3d472b9d$1_1@dnews> <3d475762$1_1@dnews> <3d4767ba$1_1@dnews> <3d4770b3_1@dnews>
Subject: Re: Question about ADOQuery
Date: Wed, 31 Jul 2002 18:05:45 +0800
Lines: 113
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 202.175.76.61
Message-ID: <3d47b6d8$1_1@dnews>
X-Trace: dnews 1028110040 202.175.76.61 (31 Jul 2002 03:07:20 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!newsfeed.gamma.ru!Gamma.RU!colt.net!newsfeed.icl.net!newsfeed.fjserv.net!lnewspeer00.lnd.ops.eu.uu.net!emea.uu.net!newsfeed01.sul.t-online.de!t-online.de!dnews