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
