Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 29F91476386 for ; Tue, 15 Oct 2002 15:32:31 -0400 (EDT) Received: from smtp.netsite.com.br (unknown [200.187.175.85]) by postgresql.org (Postfix) with ESMTP id 8271A47637C for ; Tue, 15 Oct 2002 15:32:29 -0400 (EDT) Received: from server2000 (netsite-fac-f1-065.idial.com.br [200.225.231.65]) by smtp.netsite.com.br (Postfix) with SMTP id 8AD3D2129B3; Tue, 15 Oct 2002 16:32:21 -0200 (BRST) Message-ID: <001c01c27482$ffc84280$0100a8c0@Info2000.com.br> From: =?iso-8859-1?Q?2000_Inform=E1tica?= <2000info@netsite.com.br> To: "pgsql Roberto Mello" , "PG SQL Mailim" Subject: ADO with postgreSQL Date: Tue, 15 Oct 2002 16:40:43 -0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0019_01C27469.9A999620" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/168 X-Sequence-Number: 9885 This is a multi-part message in MIME format. ------=_NextPart_000_0019_01C27469.9A999620 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi, Thank you for the previous help (INNER BETWEN MORE THAN ONE DATABASES). In the Visual Basic 6.0: Dim dbConn as Connection, rs as recordset, strSQL as string, strConn as= string strConn =3D "Provider=3DMSDASQL.1;Extended Properties=3D""DRIVER=3D{Pos= tgreSQL};DATABASE=3DMyDataBase;SERVER=3DMyServer;PORT=3D5432;ReadOnly=3D0;P= rotocol=3D6.4""" set dbConn =3D new connection dbConn.CursorLocation =3D adUseServer dbConn.Open strConn, "MyUser", "MyPasswd" strSQL =3D "select * from table1 where id =3D 1234" set rs =3D new recordset rs.open strSQL, dbConn, adOpenDynamic, adLockBatchOptimistic =20=20=20=20 In table1 the field 'field1' is of type 'money' The next command rs!field1 =3D ccur(form1.field1.text) rs.update cause the following message: ERROR: Attribute 'field1' is of the tupe 'money' but expression is of t= ype 'float8'. You will need to rewrite or cast the expression. My PostgreSQL version is 7.1. How I do to work in 'ODBC ambient' with no large changes ? Silvio 2000Info ------=_NextPart_000_0019_01C27469.9A999620 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

Thank you for the previous help (INNER BET= WEN MORE=20 THAN ONE DATABASES).

In the Visual Basic 6.0:

Dim dbConn as Connectio= n, rs as=20 recordset, strSQL as string, strConn as string

strConn =3D=20 "Provider=3DMSDASQL.1;Extended=20 Properties=3D""DRIVER=3D{PostgreSQL};DATABASE=3DMyDataBase;SERVER=3DMyServe= r;PORT=3D5432;ReadOnly=3D0;Protocol=3D6.4"""

set dbConn =3D new=20 connection

dbConn.CursorLocation = =3D=20 adUseServer
dbConn.Open strConn, "MyUser",=20 "MyPasswd"

strSQL =3D "select * fr= om table1=20 where id =3D 1234"

set rs =3D new=20 recordset

rs.open strSQL, dbConn,= =20 adOpenDynamic, adLockBatchOptimistic

In table1 the field 'field1' is of type 'money'

The next command

rs!field1 =3D ccur(form1.field1.text)

rs.update

cause the following message:

ERROR: Attribute 'field1' is of the tupe 'money' but expression is of = type=20 'float8'.

= =20 You will need to rewrite or cast the= =20 expression.

My PostgreSQL version is 7.1.

How I do to work in 'ODBC ambient' with no= large=20 changes ?

Silvio

2000Info

------=_NextPart_000_0019_01C27469.9A999620--