Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Problem with VB6, DAO, Data Control: Update does not work
- From: Peter Eisentraut <peter_e(at)gmx(dot)net>
- To: Wolfgang Fürtbauer <w(dot)fuertbauer(at)eunet(dot)at>, pgsql-odbc(at)postgresql(dot)org
- Subject: Re: Problem with VB6, DAO, Data Control: Update does not work
- Date: Fri, 13 Aug 2004 23:53:44 +0200
- Message-id: <200408132353.44050.peter_e@gmx.net> <text/plain>
Wolfgang Fürtbauer wrote: > I found out, after removing the "rabwert" = '5.225'::float4 from the > where-clause, > the update worked; so I had a look with the VB-Debugger at the value > of data1.recordset!rabwert > just before update and: the value was 5.225 > > Why does the update not work ? You can't reasonably compare floating point values for equality, because they only store approximations of what you see. And you certainly shouldn't store monetary values in floating point columns, because you are asking for rounding problems. Always use numeric. -- Peter Eisentraut http://developer.postgresql.org/~petere/
- References:
- Problem with VB6, DAO, Data Control: Update does not work
- From: Wolfgang Fürtbauer
- Problem with VB6, DAO, Data Control: Update does not work
- Prev by Date: Re: ODBC Standards Compliancy
- Next by Date: Re: Problem with VB6, DAO, Data Control: Update does not work
- Previous by thread: Problem with VB6, DAO, Data Control: Update does not work
- Next by thread: Re: Problem with VB6, DAO, Data Control: Update does not work
- Indexes: