Gen-X,

Yes, I went through your list:

1. Is the ODBC DSN created properly?
--> must have, as i'm able to get data from the database.

2. Have you run the "Test" on the ODBC and it said successful?
--> don't see this option.

3. Can you at least READ records from the database?
--> Yes.

4. Test to see what the RecordCount is for your clause first
--> = 2 (my test table has only 2 rows of data)

5. Reduce your update to only a single field
--> I'm updating the data one row at a time. It still fails when I'm only updating one column.

I'm using PostgreSQL as database (the free database that comes with Linux). I have grant all permission on the table to public.

If I run a "insert", "delete" or"update" SQL statement from VB application, the query executed successfully. I only have problem when I try to update the record set.

[Edited by carolyn on 03-22-2000 at 01:24 AM]