Re: [SQL] PostgreSQL does not support updateable cursors

Premsun Choltanwanich wrote: >      I found some information on internet about the PostgreSQL does not > support updateable cursors so I change my code to be read only cursors as >  'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", > connSystem, adOpenForwardOnly, adLockReadOnly'

[SQL] PostgreSQL does not support updateable cursors

Dear All,   I got error message 'ERROR: column "ctid" does not exist; Error while executing the query'  when I try to query SELECT on my VIEW as 'rsSystem.Open "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, adLockOptimistic'.   I found some information o