#DML Help Please!!!!
Help! What am I doing wrong here? My intention is simple — updated a field
in a database during a DML program. Code fragment follows (with debugging
print statments left intact).
REM balance1.roydetl is simply a real number
REM total% contains the total amound owed
REM Goal is to update the old balance1.roydetl with total
? "Originally ";balance1.roydetl
balance1.roydetl = total%
? "Wrote balance1.roydetl = ";total%
? "Now is ";balance1.roydetl
STORE, 1
STORE, 2
====== Sample run follows
Originally -$11.97
Wrote balance1.roydetl = $186.97
Now is $186.97
========= End sample run
Problem! Even though it claims to have updated the field, when you go back
into Superbase from DML, the field is still -$11.97!!!!! I've tried closing
the file from within DML, immediately upon exiting, etc. It doesn't make
a difference!
This is a major stumbling block for me, as I need the updated numbers to
calculate royalties for the quarter. Help!
Loyd