Article View: borland.public.cppbuilder.database.ado
Article #3548Re: Question about ADOQuery
From: Jackie
Date: Wed, 31 Jul 2002 10:05
Date: Wed, 31 Jul 2002 10:05
111 lines
4050 bytes
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!dnewsReferences:
<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