Environment:
- postgresql 8.4.0
- odbc psqlodbc_08_04_0100.zip
- pgadmin III 1.10.0
- windows xp with visual basic ado
Problem:
- a query is done in pgadmin OK, it returns one record
- the same query, when done via odbc, does not return any record. When
asking for the .recordcount property, we get the following message
(see image)
- it seems to have something to do with the casting of the argument of
the STDDEV function
If OK for pgadmin, should not be OK for ODBC?
Thank you and regards.
query
SELECT STDDEV(FIELD1+FIELD2/6) AS VALUE1 FROM tbldata (NOT OK)
SELECT STDDEV(cast(C+Mn/6 as real)) AS VALUE1 FROM tbldata (OK)
data of tbldata
FIELD1;FIELD2
0.08600;0.66000
0.10400;0.58000
