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