clipper 87 quesiton

[kathrync2003]

I'm updating a clipper 87 program and am having a problem with the "total on" command.

eg: total on heat to dup

dup is my database
heat is a field in the database
heat field is indexed

After the command is executed...
the heat number has data in it, but none of the other fields.

Does anyone know why?

 

[JockMullin]

Hi, Kathrync2003

If you don't specify the fields to total with a fields clause then nothing gets totalled. Only the first record with each new keycode gets copied to the output file "dup".

If you want fields totalled, you have to specify which ones, otherwise it will just copy the first record for each heat value to the output file.

Best regards
Jock

 

[kathrync2003]

Thanks. I tried it and it's giving me the same result as before. So, I've come to the conclusion that this isn't my problem there is something else in my code.

Thanks anyways.

 

[rob444]

If you total on a field
eg: total on heat to dup

and
dup is your database

then nothing happens.
You should use a variable in which you store the result of the total on command.

eg: total on heat to totalheat
and totalheat will contain the result.

Rob.

 

[kathrync2003]

Thanks. I'm going to try that.

 

[gbade123]

how can i uograde my clipper 87 to windows dased ?

 

[Virus12]

The problem of yours is that you did not initialize the variable to store the corresponding result into the field of entry or you have already a variable that you declared early by public.

Try to initialize the variable again before you execute that command of yours.