jwcolby
jwcolby at colbyconsulting.com
Tue Jun 10 12:59:40 CDT 2008
Mark, There are lots of accounting applications that work that way. You never delete, in fact you never update. Built-in audit trail since anything EVER ENTERED is still in there. John W. Colby www.ColbyConsulting.com Mark A Matte wrote: > Dan, > > This is a PeopleSoft App...I take no responsibility for why it is built this way...but as far as your examples... > > Update multiple records: This is a CRM package...you can only update 1 record at a time. It may involve other records in other tables...but they are all accessed from a single parent record...and only that record. > > Deletes: You are not allowed to delete...end of story. > > I didn't write it...its just the way it came. > > But if you wanted to delete...you would delete all related records in other tables and then at the end...delete the single parent record. > > Clear as mud...let me know if you have any questions. > > Thanks, > > Mark A. Matte > > >> From: dwaters at usinternet.com >> To: accessd at databaseadvisors.com >> Date: Tue, 10 Jun 2008 12:23:25 -0500 >> Subject: Re: [AccessD] VBA Unbound data entry / update form >> >> Mark, >> >> I like your example for one record at a time updates. >> >> How do you handle a situation like: >> >> UPDATE tblTable Set Field = 'TRUE' _ >> WHERE Date = CurrentDate >> >> Or: >> >> DELETE * FROM tblTable _ >> WHERE Date = CurrentDate >> >> Of course, each of these examples could involve many records. >> >> Thanks! >> Dan >> >> >> >> -----Original Message----- >> From: accessd-bounces at databaseadvisors.com >> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark A Matte >> Sent: Tuesday, June 10, 2008 11:51 AM >> To: Access Developers discussion and problem solving >> Subject: Re: [AccessD] VBA Unbound data entry / update form >> >> >> I can tell you how our PeopleSoft (web based) App handles it...it compares >> the last_update_timestamp...if it is the same as when you pulled your >> recordset...you get to save...if not...you lose your changes. >> >> Golden rule with the app we purchased...first person to click save...wins!!! >> >> Thanks, >> >> Mark A. Matte