I'm Updating a Currency Value and it doesn't change

NOS Informatica Ltda

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

I'm Updating a Currency Value and it doesn't change

I'm doing that using a TQuery. I use the common procedure:

Edit;
FieldByName('xxx').AsCurrency =Valor
Post

The problem is that I'm passing a value (902,02 for example) and it
is writing one cent less (902,01).

I'm using DELPHI 3.1 and SQLServer 6.5. I've made a trace and saw
that the program is not doing a update. The only thing that appears is a
Select Count(*) ...

Does anybody knows what fuzzy thing is happenning ?

I'd be gratefull.

Thanks

Carlos Srgio
Brasil

Luis C. Urib

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:I'm Updating a Currency Value and it doesn't change

There is a bug in Delphi 4 using currency fields where the values get
written inaccurately to the db. This may happen on 3 as well, something to
watch for.

I hope they fixed the problem on Delphi 5.

Luis

NOS Informatica Ltda <n...@fortalnet.com.br> wrote in message
news:37CEF8E1.695AEC4D@fortalnet.com.br...

Quote

> I'm doing that using a TQuery. I use the common procedure:

> Edit;
> FieldByName('xxx').AsCurrency =Valor
> Post

> The problem is that I'm passing a value (902,02 for example) and it
> is writing one cent less (902,01).

> I'm using DELPHI 3.1 and SQLServer 6.5. I've made a trace and saw
> that the program is not doing a update. The only thing that appears is a
> Select Count(*) ...

> Does anybody knows what fuzzy thing is happenning ?

> I'd be gratefull.

> Thanks

> Carlos Srgio
> Brasil

Other Threads

1. Update don't change value in column

2. Updating a row that doesn't exist - where's the error

3. TDBEdit with currency, Maskedit doesn't work

4. Currency formatting doesn't use control panel settings

5. ttable.fielddefs.update doesn't update deleted fields

6. ADODataSet1.Properties['Update Criteria'].value :=adCriteriaKey;

7. TIndexDefs.Update doesn't update

8. changing 'must have a value' message

9. TListView, OwnerDraw, Font size is changed ,but the Items size doesn't change

10. Date value from DB doesn't contain century