Can't change the contents of a field

Started by Steve Quezadasover 25 years ago1 messagesgeneral
Jump to latest
#1Steve Quezadas
steveeq2@tripperjones.com

This is weird. I can change the contents of a field in the psql command prompt, but I can't do it in Microsoft Access via ODBC. Everytime I try to change a field in Microsoft Access, it first says: "ODBC--update on a linked table 'test' failed". Then it goes on to say:

"Error while executing the query; ERROR: Unable to identify an operating '=' for types 'xid' and 'int4'. You will have to retype this query using an explicit cast. (#1)".

Does anyone know why I can't change the field? I turned off the "read only" property. I am using Postgres 7.02 with the new 6.5 version of the ODBC drive (psotdrv.exe)

- Steve