> -----Original Message----- > From: Mark Cotton [mailto:[EMAIL PROTECTED]] > Sent: 25 April 2002 21:29 > To: [EMAIL PROTECTED] > Cc: Mark Cotton > Subject: [pgadmin-support] Get "Can Not Locate the Record for > Updating in the Database" Error > > > When editing rows from within the "View Data" Option for a > Table, I get an error whenever I try to Update and/or Delete > row information. After selecting a row from within the > datasheet and pressing the EDIT and/or DELETE, I get the > following error message: > > "Can not locate the record for updating the database" > > I have checked my ODBC Configuration to ensure it is not set > to the default "READ ONLY" Settings. Can anyone tell me why I > get this error and whether there are any workarounds to this > problem, short of writing my on SQL statements by hand? Normally this error occurs if there is a timestamp field in the dataset. For some reason '2002-12-31 23:59:59' doesn't always seem to be equal to (for example) '31/12/2002 23:59:59'. I have improved the code that does the updates to use a primary key for locating records wherever possible which has made life significantly easier in this office at least :-) If you want to try a snapshot (at your own risk etc), download a tarball from http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/binaries/ and install following the instructions in the README. Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
