From Premsun@nsasia.co.th Tue Feb  12 06:34:10 2008
Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 4D3D82E0069
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 12 Feb 2008 02:34:10 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 00815-01 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 12 Feb 2008 02:33:53 -0400 (AST)
Received: from astaro.nsasia.co.th (mail.nsasia.co.th [58.137.64.34])
	by postgresql.org (Postfix) with ESMTP id 4512E2E005A
	for <pgsql-sql@postgresql.org>; Tue, 12 Feb 2008 02:34:02 -0400 (AST)
Received: from MailerDaemon by astaro.nsasia.co.th with local-bsmtp (Exim
 4.63)
	(envelope-from <Premsun@nsasia.co.th>) id 1JOoiO-0005M8-Hd
	for pgsql-sql@postgresql.org; Tue, 12 Feb 2008 13:34:00 +0700
Received: from [192.168.200.39] (port=42881 helo=kloster.nsasia.co.th)
	by astaro.nsasia.co.th with esmtp (Exim 4.63)
	(envelope-from <Premsun@nsasia.co.th>) id 1JOoiN-0005M3-Aj
	for pgsql-sql@postgresql.org; Tue, 12 Feb 2008 13:33:59 +0700
Received: from Thailand-MTA by kloster.nsasia.co.th
	with Novell_GroupWise; Tue, 12 Feb 2008 13:33:59 +0700
Message-Id: <47B19FFE.C5F7.004C.0@nsasia.co.th>
X-Mailer: Novell GroupWise Internet Agent 7.0.2 
Date: Tue, 12 Feb 2008 13:33:51 +0700
From: "Premsun Choltanwanich" <Premsun@nsasia.co.th>
To: <pgsql-sql@postgresql.org>
Subject: PostgreSQL does not support updateable cursors
Mime-Version: 1.0
Content-Type: multipart/alternative; boundary="=__Part7C5A87DF.0__="
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/85
X-Sequence-Number: 30176

This is a MIME message. If you are reading this text, you may want to 
consider changing to a mail reader or gateway that understands how to 
properly handle MIME multipart messages.

--=__Part7C5A87DF.0__=
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable

Dear All,
=20
     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.Op=
en "SELECT * FROM v_memocatlist ORDER BY memocategory", connSystem, =
adOpenStatic, adLockOptimistic'.=20
=20
     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.=20
=20
     How can I fix this problem?
=20
More Information about my system.
Database: PostgreSQL 8.3
ODBC: psqlODBC 08.03.0100
Language: MS Visual Basic 6.0
=20
Regards,
Premsun

NETsolutions Asia Limited
+66 (2) 237 7247
http://www.nsasia.co.th

--=__Part7C5A87DF.0__=
Content-Type: multipart/related; boundary="=__Part7C5A87DF.1__="

--=__Part7C5A87DF.1__=
Content-Type: text/html; charset=US-ASCII
Content-Transfer-Encoding: quoted-printable
Content-Description: HTML

<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dwindows-874=
">
<META content=3D"MSHTML 6.00.2900.3243" name=3DGENERATOR></HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt MS Sans Serif">
<DIV>Dear All,</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; I got error message '<STRONG>ERROR: column =
"ctid" does not exist; Error while executing the query</STRONG>'&nbsp; =
when I try to query SELECT on my VIEW as '<STRONG>rsSystem.Open "SELECT * =
FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenStatic, =
adLockOptimistic</STRONG>'. </DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; I found some information on internet about =
the PostgreSQL does not support updateable cursors so I change my code =
to&nbsp;be read only cursors as &nbsp;'<STRONG>rsSystem.Open "SELECT * =
FROM v_memocatlist ORDER BY memocategory", connSystem, adOpenForwardOnly, =
adLockReadOnly</STRONG>' then it work fine.&nbsp;However, I need to&nbsp;us=
e this query for make data ready to be updated on some record. </DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;&nbsp;&nbsp;&nbsp; How can I fix this problem?</DIV>
<DIV>&nbsp;</DIV>
<DIV><U>More Information about my system.</U></DIV>
<DIV>Database: PostgreSQL 8.3<BR>ODBC: psqlODBC 08.03.0100<BR>Language: MS =
Visual Basic 6.0</DIV>
<DIV>&nbsp;</DIV>
<DIV>Regards,</DIV>
<DIV>Premsun</DIV><BR>

    <p>
      <font size=3D"2" color=3D"#0033cc" face=3D"Trebuchet MS"><b>NETsoluti=
ons Asia=20
      Limited </b></font>
    </p>
    <p>
      <font size=3D"2" color=3D"#0033cc" face=3D"Trebuchet MS"><b>+66 (2) =
237 7247 </b></font>

    </p>
    <p>
      <a href=3D"http://www.nsasia.co.th"><img border=3D"0" alt=3D"NETsolut=
ions Asia Limited" src=3D"cid:RQHFQWYUJULD.44e30700.jpg">
</a>    </p>
  </BODY></HTML>

--=__Part7C5A87DF.1__=
Content-Type: IMAGE/jpg; name="IMAGE.jpg"
Content-Transfer-Encoding: base64
Content-ID: <RQHFQWYUJULD.44e30700.jpg>
Content-Description: JPEG image

/9j/4AAQSkZJRgABAQEBLAEsAAD/4gxYSUNDX1BST0ZJTEUAAQEAAAxITGlubwIQAABtbnRyUkdC
IFhZWiAHzgACAAkABgAxAABhY3NwTVNGVAAAAABJRUMgc1JHQgAAAAAAAAAAAAAAAAAA9tYAAQAA
AADTLUhQICAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABFj
cHJ0AAABUAAAADNkZXNjAAABhAAAAGx3dHB0AAAB8AAAABRia3B0AAACBAAAABRyWFlaAAACGAAA
ABRnWFlaAAACLAAAABRiWFlaAAACQAAAABRkbW5kAAACVAAAAHBkbWRkAAACxAAAAIh2dWVkAAAD
TAAAAIZ2aWV3AAAD1AAAACRsdW1pAAAD+AAAABRtZWFzAAAEDAAAACR0ZWNoAAAEMAAAAAxyVFJD
AAAEPAAACAxnVFJDAAAEPAAACAxiVFJDAAAEPAAACAx0ZXh0AAAAAENvcHlyaWdodCAoYykgMTk5
OCBIZXdsZXR0LVBhY2thcmQgQ29tcGFueQAAZGVzYwAAAAAAAAASc1JHQiBJRUM2MTk2Ni0yLjEA
AAAAAAAAAAAAABJzUkdCIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAWFlaIAAAAAAAAPNRAAEAAAABFsxYWVogAAAAAAAAAAAAAAAA
AAAAAFhZWiAAAAAAAABvogAAOPUAAAOQWFlaIAAAAAAAAGKZAAC3hQAAGNpYWVogAAAAAAAAJKAA
AA+EAAC2z2Rlc2MAAAAAAAAAFklFQyBodHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAFklFQyBo
dHRwOi8vd3d3LmllYy5jaAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAAAABkZXNjAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAt
IHNSR0IAAAAAAAAAAAAAAC5JRUMgNjE5NjYtMi4xIERlZmF1bHQgUkdCIGNvbG91ciBzcGFjZSAt
IHNSR0IAAAAAAAAAAAAAAAAAAAAAAAAAAAAAZGVzYwAAAAAAAAAsUmVmZXJlbmNlIFZpZXdpbmcg
Q29uZGl0aW9uIGluIElFQzYxOTY2LTIuMQAAAAAAAAAAAAAALFJlZmVyZW5jZSBWaWV3aW5nIENv
bmRpdGlvbiBpbiBJRUM2MTk2Ni0yLjEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAHZpZXcAAAAA
ABOk/gAUXy4AEM8UAAPtzAAEEwsAA1yeAAAAAVhZWiAAAAAAAEwJVgBQAAAAVx/nbWVhcwAAAAAA
AAABAAAAAAAAAAAAAAAAAAAAAAAAAo8AAAACc2lnIAAAAABDUlQgY3VydgAAAAAAAAQAAAAABQAK
AA8AFAAZAB4AIwAoAC0AMgA3ADsAQABFAEoATwBUAFkAXgBjAGgAbQByAHcAfACBAIYAiwCQAJUA
mgCfAKQAqQCuALIAtwC8AMEAxgDLANAA1QDbAOAA5QDrAPAA9gD7AQEBBwENARMBGQEfASUBKwEy
ATgBPgFFAUwBUgFZAWABZwFuAXUBfAGDAYsBkgGaAaEBqQGxAbkBwQHJAdEB2QHhAekB8gH6AgMC
DAIUAh0CJgIvAjgCQQJLAlQCXQJnAnECegKEAo4CmAKiAqwCtgLBAssC1QLgAusC9QMAAwsDFgMh
Ay0DOANDA08DWgNmA3IDfgOKA5YDogOuA7oDxwPTA+AD7AP5BAYEEwQgBC0EOwRIBFUEYwRxBH4E
jASaBKgEtgTEBNME4QTwBP4FDQUcBSsFOgVJBVgFZwV3BYYFlgWmBbUFxQXVBeUF9gYGBhYGJwY3
BkgGWQZqBnsGjAadBq8GwAbRBuMG9QcHBxkHKwc9B08HYQd0B4YHmQesB78H0gflB/gICwgfCDII
RghaCG4IggiWCKoIvgjSCOcI+wkQCSUJOglPCWQJeQmPCaQJugnPCeUJ+woRCicKPQpUCmoKgQqY
Cq4KxQrcCvMLCwsiCzkLUQtpC4ALmAuwC8gL4Qv5DBIMKgxDDFwMdQyODKcMwAzZDPMNDQ0mDUAN
Wg10DY4NqQ3DDd4N+A4TDi4OSQ5kDn8Omw62DtIO7g8JDyUPQQ9eD3oPlg+zD88P7BAJECYQQxBh
EH4QmxC5ENcQ9RETETERTxFtEYwRqhHJEegSBxImEkUSZBKEEqMSwxLjEwMTIxNDE2MTgxOkE8UT
5RQGFCcUSRRqFIsUrRTOFPAVEhU0FVYVeBWbFb0V4BYDFiYWSRZsFo8WshbWFvoXHRdBF2UXiReu
F9IX9xgbGEAYZRiKGK8Y1Rj6GSAZRRlrGZEZtxndGgQaKhpRGncanhrFGuwbFBs7G2MbihuyG9oc
AhwqHFIcexyjHMwc9R0eHUcdcB2ZHcMd7B4WHkAeah6UHr4e6R8THz4faR+UH78f6iAVIEEgbCCY
IMQg8CEcIUghdSGhIc4h+yInIlUigiKvIt0jCiM4I2YjlCPCI/AkHyRNJHwkqyTaJQklOCVoJZcl
xyX3JicmVyaHJrcm6CcYJ0kneierJ9woDSg/KHEooijUKQYpOClrKZ0p0CoCKjUqaCqbKs8rAis2
K2krnSvRLAUsOSxuLKIs1y0MLUEtdi2rLeEuFi5MLoIuty7uLyQvWi+RL8cv/jA1MGwwpDDbMRIx
SjGCMbox8jIqMmMymzLUMw0zRjN/M7gz8TQrNGU0njTYNRM1TTWHNcI1/TY3NnI2rjbpNyQ3YDec
N9c4FDhQOIw4yDkFOUI5fzm8Ofk6Njp0OrI67zstO2s7qjvoPCc8ZTykPOM9Ij1hPaE94D4gPmA+
oD7gPyE/YT+iP+JAI0BkQKZA50EpQWpBrEHuQjBCckK1QvdDOkN9Q8BEA0RHRIpEzkUSRVVFmkXe
RiJGZ0arRvBHNUd7R8BIBUhLSJFI10kdSWNJqUnwSjdKfUrESwxLU0uaS+JMKkxyTLpNAk1KTZNN
3E4lTm5Ot08AT0lPk0/dUCdQcVC7UQZRUFGbUeZSMVJ8UsdTE1NfU6pT9lRCVI9U21UoVXVVwlYP
VlxWqVb3V0RXklfgWC9YfVjLWRpZaVm4WgdaVlqmWvVbRVuVW+VcNVyGXNZdJ114XcleGl5sXr1f
D19hX7NgBWBXYKpg/GFPYaJh9WJJYpxi8GNDY5dj62RAZJRk6WU9ZZJl52Y9ZpJm6Gc9Z5Nn6Wg/
aJZo7GlDaZpp8WpIap9q92tPa6dr/2xXbK9tCG1gbbluEm5rbsRvHm94b9FwK3CGcOBxOnGVcfBy
S3KmcwFzXXO4dBR0cHTMdSh1hXXhdj52m3b4d1Z3s3gReG54zHkqeYl553pGeqV7BHtje8J8IXyB
fOF9QX2hfgF+Yn7CfyN/hH/lgEeAqIEKgWuBzYIwgpKC9INXg7qEHYSAhOOFR4Wrhg6GcobXhzuH
n4gEiGmIzokziZmJ/opkisqLMIuWi/yMY4zKjTGNmI3/jmaOzo82j56QBpBukNaRP5GokhGSepLj
k02TtpQglIqU9JVflcmWNJaflwqXdZfgmEyYuJkkmZCZ/JpomtWbQpuvnByciZz3nWSd0p5Anq6f
HZ+Ln/qgaaDYoUehtqImopajBqN2o+akVqTHpTilqaYapoum/adup+CoUqjEqTepqaocqo+rAqt1
q+msXKzQrUStuK4trqGvFq+LsACwdbDqsWCx1rJLssKzOLOutCW0nLUTtYq2AbZ5tvC3aLfguFm4
0blKucK6O7q1uy67p7whvJu9Fb2Pvgq+hL7/v3q/9cBwwOzBZ8Hjwl/C28NYw9TEUcTOxUvFyMZG
xsPHQce/yD3IvMk6ybnKOMq3yzbLtsw1zLXNNc21zjbOts83z7jQOdC60TzRvtI/0sHTRNPG1EnU
y9VO1dHWVdbY11zX4Nhk2OjZbNnx2nba+9uA3AXcit0Q3ZbeHN6i3ynfr+A24L3hROHM4lPi2+Nj
4+vkc+T85YTmDeaW5x/nqegy6LzpRunQ6lvq5etw6/vshu0R7ZzuKO6070DvzPBY8OXxcvH/8ozz
GfOn9DT0wvVQ9d72bfb794r4Gfio+Tj5x/pX+uf7d/wH/Jj9Kf26/kv+3P9t////2wBDAAIBAQIB
AQICAgICAgICAwUDAwMDAwYEBAMFBwYHBwcGBwcICQsJCAgKCAcHCg0KCgsMDAwMBwkODw0MDgsM
DAz/2wBDAQICAgMDAwYDAwYMCAcIDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwMDAwM
DAwMDAwMDAwMDAwMDAz/wAARCAAgAHIDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAEC
AwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0Kx
wRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1
dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ
2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QA
tREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk
NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaH
iImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq
8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD9/K4z47/tEeB/2YPATeKPiF4p0bwf4dS4jtW1DVLgQW4l
kzsTce7YOB7V2dflf/wdHfHzwP4g/wCCf7+CLTxPo+oeJ5PFelzSaba3AmmijR5A5fZkJjPRiD6V
6GUYWlisdRwlWXKqklHz17X6jlRryo1KtGDlyJydk3ZLq7bLzZ9af8Pov2Uf+i//AAx/8HMdH/D6
L9lH/ov/AMMf/BzHX4xfHD/glT8IdG+I/wAVPEvgrTrrUPh14fvtL8NNp819Kbnwlrw13TbS7tpG
3bniubO4kmgdiflkccNFXgH7cth8Hf2dvjZrGk+GPBXwG8TWvhzxXf6U2jaZrXiWTURbxNNEq3pm
eOMbSE3GF8+YoxlCa/RsJwVlOJko0J1W35R00Ts77bpdvO2p4M8yrwTclH8T+hs/8Fov2UR/zX/4
Zf8Ag5jrg/iJ/wAHD/7JPgCdoYvilZeIp1ONujWstwpP/XQhY/x3Yr8Wvid+wT8NPjz+3T8Sfhj4
ZttH+EOlfDaS3trCHTZJdR1LxTJdNCoUf2heRwl4t7v5aSLJIvyojt08+8Jf8EuNPSLTdP1nxlfw
+O7nRNQ8ZJ4dl0CSC0k0fTtSlsriKa5aQPBeOLedxGYyqbQjOHYU3wNlE6af1ipBtJ2cU3Zq62TW
2t7tLqdOEzeVOrzV6KqR7KTjt57/AJM/YrxD/wAHO3wkvb17bwzp9hPzhLjWvENtp8f1IUSH9RWd
/wAP0tR8d/8AHl8UP2VvBcDjhtR8USXsyfUIQP0r8lfjx/wTC0fT/jv4jg0TxE2heG5J/H+oWNiL
JrqTTbTw3cSKsG9pAZDKigBmI2nGc5rt/wBoP/glr8Pbbxp4ktPCWtXPh/wb4R8Q66dU1S7sZbzW
Law0vQbHUZ4kj8/ypyXnIj4jbdIxdgigDl/4h7ksuVTxlZ8yb2irW0fwxTvfte9vQ9v/AF0nTu8N
gKELdWpzf3VKk4/+Sr0P0pf/AIKOv4pjC6r+3p8A9DVjll0Szt2K+oDSrn9alsv2mvhX4gmjTU/+
CjIuLiVgqx6Zf21sZGJwFAQ55PAA5r8rPCH/AASA8L+JU8L3U3xZ1O20z4l6pomleCpU8LB5rttW
sZbuB75DcD7MsbQvHJsMmeHTINZXh3/gn1afBPT/AILfEvTPGE3iqW78XeG4tXhstPiNjpM13OJB
A8qztPDLG0ezFxBEJSS0RdRVf8Q44efurEVJPz5t+i1VunyF/wARAzuPwRpw/wAFKjH/ANJgmfsl
JYfB7UOdR/bD+LN4x++RrV3Hn6AJgU5PDvwChbdH+1b8Wlk7t/wkd4c/+Q66/wCLX/BTDWvBH/BU
TS/CMOqwx/CbR9QsfA2vwf2TLJv1rUYXniu/toj8qNIHNhbNG0gJa+Y7TtFOg/4Kta342tNesNQ8
LzeAdW0jxBoVvDZrqIbVHtLvXYtOdpYrm1EbQlWVjNbNNEVl2rKrgGviv9U8NaMlhrqSi/ijpzOy
veHpe17XVzvfHGdXa+uTVr7Nrb0djjJ9b+Gvhm2abS/22fiLpSx879Qvpbm3j9281NoX1JOK9s1b
R/2mv2adFn12Hxj4V+MXh3Tomubmx1KyTTL8wICzNHPHhN20HG4MK8P+PH/BS+X9qb9nL4/eCJfC
9lp1oPhhrfiLTNT0/Upr2G5t4J/sbxtI1vFDI5MiOHtpJosEqXyOfTLXwN8af+Cg3h2x0rxLaS/C
H4QvBElxp6S+ZrXiGEKPkkYY8uNh1UAAg87+lePnWS08HGCpUpQnK+nNorKNm2ko9dmne2iZ7mSc
Q4rGylUzKtTlRhbm9pCMpNO/uwT/AHjbS3jKKjpzTjdM9r8D/wDBQH4eeNvBej6yl7eWqavZQ3oh
ktmLwiSNX2kjgkbsHHHFFd34c/Z48FeFfD1hpdn4b0tLTTbeO1gVoQxVEUKoJPU4A5orKMZJJSev
p/wT5mtVwzqSdOm1G7sua9l0Xwnzd4pu/iJ/wUK+K3ifw1omu3ngH4PeE9Rl0bUb6xbZqniO4iO2
aNH6xxA5GBjI5OchR59/wU1/4Iu6f8bP2CLj4a/BLRvDOheKH1qx1JtR1WRhLdJCzF98+1m3HcDg
AA4r374n/sP6rD8RNU8ZfCvx7q/w51/W5ftGpWsca3WlanNjHmyW75UOR1YDJrCkh/a78G/JDcfC
LxiidHmhuLKST67WAH5Vjl+LxGAxMcXCDdSLupLlfXTRtNLytb13PrMxWFzLDxw2GxkKVGy/dSU4
2lazbcYyhOTd/flJSa+zFWivych/4N8P267fVfF19H8TvCqXXj67tr/xG416Uf2zcW063FvNMPJw
zxyqHU4yCPQkVc+NX/BA39u/9ozRH07xx8RvAHiO0kuxfutxdxo8k43fvGeO1V2b5mzluc85r9VH
+LH7W9o4V/hX8Mrkf3odekUH8C1H/C0/2ub1iIvhf8LrQdmn1yR/0V6+uXiPmvMpKCutn7KHkt7d
kl8kfN/6jUbf71St/wBff03/AAPyt8Jf8EE/29fA3xI8Q+L9M+J/gyHxH4s8o6zey6n9oOpNEytC
8qSW7IXjZFZH27kYZUg80sP/AAQY/b7g+Hl54UHxY8MNoN/cy3Vxbya5JJJK8twLmUGZoDKI5LgC
V4w+x3G5lJ5r9TZLn9sTxApCw/BrQN3AO25uGX3++RTH+A/7VvikEaj8a/CGhxv1TSvDiMy/RpFz
+tJ+ImcSd/Yp7fYpdNuvTp2KXBuWxX7zMKS8v37/APSaLX4n5gW//BDT/goHa+EfEmhJ8WvCf9le
L5r+41iFtWLNevf/APH7mQ25dVuMAyKjKrkAkZANUfE//BFf9vLR9d0vxFrHxr8E2V9ocz3VreXW
viEJI1qlnIz7oAsm+2jSJ/MDB0XDZr9S1/4J0eO/FcQXxb+0X8UNUjfmWCwlXT42+nln+lW9G/4I
9/BuO6W41228S+MLkHc0mt6xLcbj64yKn/XzPXrGnSV+8Y3132g/zH/q9w5T0q4urNr+Snp986kG
v/AH6H4j/E79hv8AaG8MeLU1jXv2p/hHLren6xba/CLPxM13Na39rB9ntpoore3YIYof3aIihVXg
KKyfBf7MP7UfxCuvBuj2/iPVviPoPhLVtN1O00yHTLmOC9+wyBrdJbgwLLIkalkj8zeIw52gV/RR
8P8A9jf4V/C0L/YPgDwtYMn3XFgkjj/gTgn9a9Igt47WFY4kSONRhVVQAPwFW+NM8kkp1Kat/LSi
mvRu/wCSM/Y5BRbdHCzm/wDp5Vdn/wBu04wa/wDA2fAfhzTP2i/iT8Ktf0G7/ZS+CumeHvF2pya1
q+mar44uYjqF7JMtw1xIq2bEyGVEfccEFFx0GKXhj9l34x+DrjUJNO/ZV/Z1gOp3FvczKfiDfyIj
QXYvIViVrErDGtyBMI4wqb/mK5r9DKK86GbVox5V131er7vXfQ8ipRhObklbyWy8le7+9s/M3xL+
wz8bLr4deMtC8Mfs6/AXwVfeNPD134Xl1e08f6hdS6dY3LB3ihje02rEsgEghQogYcAZNfpN4esX
0zQLG2lwZbe3jifByMqoB/lVyisMZj6uJt7Tpfv1t3b7IKdKMNgoooriNT//2Q==

--=__Part7C5A87DF.1__=--

--=__Part7C5A87DF.0__=--



From peter_e@gmx.net Sun Feb  17 15:21:41 2008
Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id 2068F2E0032
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 17 Feb 2008 11:21:41 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 77020-02 for <pgsql-sql-postgresql.org@postgresql.org>;
	Sun, 17 Feb 2008 11:21:31 -0400 (AST)
Received: from mail.gmx.net (mail.gmx.net [213.165.64.20])
	by postgresql.org (Postfix) with SMTP id 311422E0030
	for <pgsql-sql@postgresql.org>; Sun, 17 Feb 2008 11:21:40 -0400 (AST)
Received: (qmail invoked by alias); 17 Feb 2008 15:21:38 -0000
Received: from xdsl-87-79-142-134.netcologne.de (EHLO colt.pezone.net)
	[87.79.142.134]
	by mail.gmx.net (mp002) with SMTP; 17 Feb 2008 16:21:38 +0100
X-Authenticated: #495269
X-Provags-ID: V01U2FsdGVkX1/M0Vk7SebMReH9ys9Y16LrW7VnMLPa5VzrsWrnKu
	vCbR4nnu5zd4D2
From: Peter Eisentraut <peter_e@gmx.net>
To: pgsql-sql@postgresql.org
Subject: Re: PostgreSQL does not support updateable cursors
Date: Sun, 17 Feb 2008 16:21:36 +0100
User-Agent: KMail/1.9.7
Cc: "Premsun Choltanwanich" <Premsun@nsasia.co.th>
References: <47B19FFE.C5F7.004C.0@nsasia.co.th>
In-Reply-To: <47B19FFE.C5F7.004C.0@nsasia.co.th>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline
Message-Id: <200802171621.36751.peter_e@gmx.net>
X-Y-GMX-Trusted: 0
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200802/140
X-Sequence-Number: 30231

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' 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?

8.3 supports updatable cursors.  Try that.

-- 
Peter Eisentraut
http://developer.postgresql.org/~petere/