change value recordset

[damianodec]

hi,
I would like to change a recordset value:

Code: Select all  Expand view

...
oResi := FW_OpenRecordSet( oCn, tuple, 1 )
...
oResi:Fields("TOTQTA"):value = 10180,00
...
 

I know that oResi:Fields("TOTQTA"):value = 10180,00 is wrong but is there any way to change it?

thank you

[damianodec]

is it impossible?

[Enrico Maria Giordano]

It looks correct to me. But change comma with dot:

Code: Select all  Expand view

oResi:Fields("TOTQTA"):value = 10180.00

And commit the change with

Code: Select all  Expand view

oResi:Update()

EMG

[damianodec]

hi Enrico, doesn't work.

in line 588:

Code: Select all  Expand view

oResi:Fields("TOTQTA"):value = nTotaleVenduti - nTotaleResi

I get this:
Time from start: 0 hours 0 mins 23 secs
Error occurred at: 01-08-2019, 15:26:37
Error description: Error ADODB.RecordSet:FIELDS/0 S_OK: _VALUE
Args:
[ 1] = N 542845.0000

Stack Calls
===========
Called from: => TOLEAUTO:_VALUE( 0 )
Called from: gesres.prg => GESRES11( 588 )

[Enrico Maria Giordano]

What is the field type of TOTQTA?

EMG

[damianodec]

decimal(12, 3)

[Enrico Maria Giordano]

You are assigning

542845.0000

Try with

542845.000

or change the field type to double or currency (or something similar that is supported by your database engine).

EMG