[AccessD] Editing Records

Yea I like that. The principle I was suggesting, though, was just a
single edit and update for each record, and only if there was something
to do. But this is certainly neat.

Andy Lacey
http://www.minstersystems.co.uk



> -----Original Message-----
> From: accessd-admin at databaseadvisors.com 
> [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Jim DeMarco
> Sent: 05 March 2003 19:56
> To: accessd at databaseadvisors.com
> Subject: RE: [AccessD] Editing Records
> 
> 
> In cases where a number of items (boolean variables in this 
> case) must be true for an event to occur I usually multiply 
> the booleans by each other.  If I get a 0 result I know the 
> event should not happen:
> 
> blnDoTheEvent = ((blnValidate1 * blnValidate2 * blnValidate3) <> 0)
> 
> If blnDoTheEvent Then
>   'do it here
> End If
> 
> HTH,
> 
> Jim DeMarco
> Director of Product Development
> HealthSource/Hudson Health Plan
> 
> 
> -----Original Message-----
> From: Bob Gajewski [mailto:bob at renaissancesiding.com]
> Sent: Wednesday, March 05, 2003 2:50 PM
> To: 'accessd at databaseadvisors.com'
> Subject: RE: [AccessD] Editing Records
> 
> 
> Andy
> 
> Just shooting from the hip, but couldn't that be done using a loop?
> 
> Seems like it might be a lot of coding, even for just 13 
> validations ... and then it would handle more if they were 
> added later.
> 
> Regards,
> Bob Gajewski
> 
> On Wednesday, March 05, 2003 14:22 PM, Andy Lacey 
> [SMTP:andy at minstersystems.co.uk] wrote:
> > Tim
> > Just a suggestion
> >  
> > Dim blnNeedsUpdate As Boolean
> >  
> > 
> > blnNeedsUpdate =False
> > 
> > If validation1 = false then 
> >         blnNeedsUpdate =True
> > 
> > End if
> > 
> > If validation2 = false then 
> >         blnNeedsUpdate =True
> > 
> > End if
> > 
> > 
> > etc
> > 
> > if blnNeedsUpdate = true
> > 
> > ..edit
> > 
> > change all fields
> > 
> > ..update
> > 
> >  
> > 
> > Andy Lacey
> > http://www.minstersystems.co.uk <http://www.minstersystems.co.uk/>
> > 
> > 
> > 
> > -----Original Message-----
> > From: accessd-admin at databaseadvisors.com
> > [mailto:accessd-admin at databaseadvisors.com] On Behalf Of Swisher, 
> > Timothy B
> > Sent: 05 March 2003 13:06
> > To: accessd at databaseadvisors.com
> > Subject: [AccessD] Editing Records
> > 
> > 
> > 
> > Hello group, I have a procedure (A2k) that opens a 
> recordset (DAO) and 
> > cycles through the data validating/updating several fields for each 
> > record.  My question is, what is the best way to do this,
> > 
> > Like this
> > 
> > ..edit
> > If validation1 = false then 
> >         change data 
> > End if 
> > 
> > If validation2 = false then 
> >         change data
> > End if 
> > ..update 
> > 
> > Or
> > 
> > If validation1 = false then 
> >         .edit 
> >         change data 
> >         .update
> > End if 
> > 
> > If validation2 = false then 
> >         .edit 
> >         change data 
> >         .update
> > End if 
> > 
> > I have about 13 validations that need to be done on about 90,000 
> > records.  Each validation goes to a SQL Server BE and check the 
> > validity of the data.  There is a huge difference in speed 
> opening and 
> > closing the recordset so many times, but if that is the 
> better way to 
> > go, then so be it.  All help is appreciated.  TIA
> > 
> > Tim
> > 
> >  << File: ATT00006.htm >>
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
> 
> 
> 
> **************************************************************
> *********************
> "This electronic message is intended to be for the use only 
> of the named recipient, and may contain information from 
> HealthSource/Hudson Health Plan (HS/HHP) that is confidential 
> or privileged.  If you are not the intended recipient, you 
> are hereby notified that any disclosure, copying, 
> distribution or use of the contents of this message is 
> strictly prohibited.  If you have received this message in 
> error or are not the named recipient, please notify us 
> immediately, either by contacting the sender at the 
> electronic mail address noted above or calling HS/HHP at 
> (914) 631-1611. If you are not the intended recipient, please 
> do not forward this email to anyone, and delete and destroy 
> all copies of this message.  Thank You".
> **************************************************************
> *********************
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/a> ccessd
> Website: 
> http://www.databaseadvisors.com
>