Hi, Hank.

Ain't it *fun* when you inherit a pile of dog doodoo? :(

I don't see any other answers so I'll give it a shot. But first I need a little background (sorry if this is obvious < s > ).

1. Are you editing this remote view in a data entry form?
2. What version of VFP are you using? 3.0b, 5.0a, or 6.0?
3. Are you pretty sure you have current ODBC drivers for PostreSQL (? Sounds like a breakfast cereal!)
4. Are there any oddball field names in the remote view or are they all just named the same as from the source?
5. Are there any spaces in any of the field names (I don't know the backend, so don't know if that's legal)

As for setting up the view, you may want to rebuild the view. First you could rename the original one, and then start a new one fresh.

Anyway, in the update tab of the view designer you want to have the primary key (in the data source) checked.

It sounds like you DO want Send SQL Updates so the back end gets updated.
Set SQL Where Clause to Key and Modified fields. (thanks to Jim Booth for clarifying my knowledge of this confusing mess...er...option). That set of choices just means that when the updates are sent "back" to the source the source is searched for records that have the same key and only the modified fields are checked for conflicts. (meaning less likelihood of conflicts).

If you are still getting conflicts, then it seems to me that the problem *might* be on the backend...IOW you may not have access to change what you are trying to change. Could this possibly be the case?

I would also guess that you don't want to have the primary key field marked to update.

I hope that helps. If something is unclear, please assume it's my limited communction skills.

Good luck.

BTW, for being not a programmer...starting out with Client/Server is kinda even worse than sink or swim!

>I am getting a "conflict error" when I edit records in a remote view. I am connecting to a PostgreSQL(?) database running on an AIX machine. I am not a programmer although I have had some FP experience. The developer has left me with little support. I am using the View Designer to access the table and have tried every combination of options for the SQL UPDATE and SQL Delete and Insert along with the SQL WHERE options. Does anyone have any suggestions?