From: 2000 Informática <2000info@netsite.com.br>
To: pgsql Roberto Mello <rmello@cc.usu.edu>
To: PG SQL Mailim <pgsql-sql@postgresql.org>
Subject: ADO with postgreSQL
Date: Tue, 15 Oct 2002 16:40:43 -0300
Message-ID: <001c01c27482$ffc84280$0100a8c0@Info2000.com.br> (raw)
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 = "Provider=MSDASQL.1;Extended Properties=""DRIVER={PostgreSQL};DATABASE=MyDataBase;SERVER=MyServer;PORT=5432;ReadOnly=0;Protocol=6.4"""
set dbConn = new connection
dbConn.CursorLocation = adUseServer
dbConn.Open strConn, "MyUser", "MyPasswd"
strSQL = "select * from table1 where id = 1234"
set rs = new recordset
rs.open strSQL, dbConn, adOpenDynamic, adLockBatchOptimistic
In table1 the field 'field1' is of type 'money'
The next command
rs!field1 = ccur(form1.field1.text)
rs.update
cause the following message:
ERROR: Attribute 'field1' is of the tupe 'money' but expression is of type '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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: 2000info@netsite.com.br, rmello@cc.usu.edu
Subject: Re: ADO with postgreSQL
In-Reply-To: <001c01c27482$ffc84280$0100a8c0@Info2000.com.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox