RE: RV: no updateable recordset

> -----Original Message-----
> From: Manuel Martínez Valls [mailto:mmartinezv(at)sanostra(dot)es]
> Sent: 18 June 2001 09:43
> To: Paja; pgsql-odbc(at)postgresql(dot)org
> Subject: RE: [ODBC] RV: no updateable recordset
>
>
> Hi again,
>
> I've followed your advice and I've created this table, after
> that reading the PostgreSQL ODBC FAQ I've realized that they
> recommend to install the pgAdmin utility, so that's what I've done.
>
> Now I have created the msysconf table as you told me, I've
> the following
> values:
>
> config=101, nvalue=1, comments='Allow local storage of
> passwords in attachments' config=102, nvalue=10,
> comments='Background population delay' config=103,
> nvalue=100, comments='Background population size'
>
> Now, I can't see any error on the logs, but I still having
> the same no-uptdateable recordsets.
>

The msysconf table won't fix this problem though it will make the error
message go away. Some things to check:

1) Read only should not be set in the driver. Be careful, there are 2 boxes
that could be checked.
2) Make sure you have unique index/primary key on your table (and it's
included in your SELECT).
3) Make sure 'Recognize Unique Indexes' is switched on in the driver.
4) Don't include a trailing ; on your queries. This makes ADO recordsets
read only and may affect DAO as well.

HTH, regards, Dave.