2. ASPRunnerPro General questions
  3. UPDATE AND ONE LINE BETWEEN 2 ANOTHER LINES
This topic is locked

UPDATE AND ONE LINE BETWEEN 2 ANOTHER LINES

 		10/20/2007 7:27:02 AM
ASPRunnerPro General questions
R
 rutzi author

Hallo! <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=6567&image=1&table=forumtopics' class='bbc_emoticon' alt=':unsure:' />
Thanks' for a great program. I have bayed all from 4.0 to 5.1 and this make the days easier!!!!!!
I have 2 question.
1)

I have make a database whit fields that calculate. My problem is that if I type something wrong and wont to change one of the field then the Sum field don't change. It's still show the same I put in the first time. The code I use is *dict("SUM")=dict("m")dict("Enhetspris")in Edit page and Before record update. Hove can I get this to work whit update the Sum field???
2)**

I use this database to give price to my customer. And this make it to be many lines ore fields

In one price. Sometimes I forget something, and wont this in between 2 lines and not in the end of the table. How can I put inn a line between 2 lines, ore to say it one different way, how can I put the line there I wont to have it. I don't wont it on the end of the table.
Hope you understand what I mean, and I looking forward to hear from you.
Regards Rune H
Sergey Kornilov admin 10/20/2007

Rune,
your syntax for calculating the sum is correct. Just in case try the following:
dict("SUM")=CDbl(dict("m"))*CDbl(dict("Enhetspris"))
R
 		rutzi author 10/21/2007

Rune,

your syntax for calculating the sum is correct. Just in case try the following:
dict("SUM")=CDbl(dict("m"))*CDbl(dict("Enhetspris"))


Hallo!
No this didn't work 'dict("SUM")=CDbl(dict("m"))*CDbl(dict("Enhetspris"))

The SUM field still show the same amount that I first put in. It doesn't update after I eks putt in a new "m"
Regards Rune H
Sergey Kornilov admin 10/21/2007

Rune,
make sure SUM field is checked off on "Choose fields" tab.