Re: Get "Can Not Locate the Record for Updating

> -----Original Message-----
> From: Mark Cotton [mailto:mark@openmfg.com]
> Sent: 25 April 2002 21:29
> To: pgadmin-support@postgresql.org
> 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.