| From: | "Premsun Choltanwanich" <Premsun(at)nsasia(dot)co(dot)th> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | PostgreSQL does not support updateable cursors |
| Date: | 2008-02-12 06:33:27 |
| Message-ID: | 47B19FE5.C5F7.004C.0@nsasia.co.th |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 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' then it work fine. However, I need to use this query for make data ready to be updated on some record.
How can I fix this problem?
More Information about my system.
Database: PostgreSQL 8.3
ODBC: psqlODBC 08.03.0100
Language: MS Visual Basic 6.0
Regards,
Premsun
NETsolutions Asia Limited
+66 (2) 237 7247
http://www.nsasia.co.th
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-02-12 06:43:45 | Re: SPI_ERROR_CONNECT |
| Previous Message | Tom Lane | 2008-02-12 06:32:18 | Re: SELECT CAST(123 AS char) -> 1 |