With the primary key!!!! Never change it - otherwise the update will not work!
Regards, Henner > -----Urspr�ngliche Nachricht----- > Von: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]] Im > Auftrag von Paul Mahoney > Gesendet: Freitag, 24. Januar 2003 16:54 > An: 'Carlos Anjos' > Cc: [EMAIL PROTECTED] > Betreff: RE: [dbforms] RE: Interceptor - preUpdate > > > Hi Carlos > > The problem is that the primary key may be being updated. > Thus I need to get a reference to the table row being updated > but the fieldValues hash may not hold the original primary > key. I can't help thinking that the innards of dbforms must > be able to identify the row to be updated, else how does it do it? > > Many thanks for responding > > Paul > > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of > > Carlos Anjos > > Sent: 24 January 2003 15:43 > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > Subject: Re: [dbforms] RE: Interceptor - preUpdate > > > > > > Hi Paul. > > Perhaps you could get from the fieldValues hashTable some id > > of the row > > you are tying to update and do some sql query using the connection > > provided, to find what the current values are. > > > > Regards, > > Carlos. > > > > > > > > Dear Team > > > > > > > > I have a preUpdate interceptor installed and the > fieldValues hash > > > > tells me the new (updated) column values. > > > > > > > > Is there a way to get to the current (pre update) column values > > > > for the target row? > > > > > > > > I need this information to decide if the update should proceed. > > > > > > > > Many thanks > > > > > > > > Paul > > > > > > > > > > > ------------------------------------------------------- > This SF.NET email is sponsored by: > SourceForge Enterprise Edition + IBM + LinuxWorld = Something > 2 See! http://www.vasoftware.com > _______________________________________________ > DbForms Mailing List > http://www.wap-force.net/dbforms ------------------------------------------------------- This SF.NET email is sponsored by: SourceForge Enterprise Edition + IBM + LinuxWorld = Something 2 See! http://www.vasoftware.com _______________________________________________ DbForms Mailing List http://www.wap-force.net/dbforms
