#DML Help Please!!!!
3 messages in this thread
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
Loyd,
Is there a particular reason you use STORE,1 STORE,2 instead of just plain
STORE
I've never had any problems with STORE, though I've never used the optional
parameters with it.
-Chas
<f> Well, whatever it was cleared itself up. I hate it when that happens
(except that it works now). I started with STORE, but that didn't seem to
work, so I tried STORE,1 & STORE,2.
Loyd