topic Re: Subtracting two numbers in vbscript on a form in ArcPad Questions

Subtracting two numbers in vbscript on a form

JamesIreland — Wed, 14 Jul 2010 14:57:47 GMT

Hello,

I have attached two pics of my login form.
The "working login form.jpg" shows:
Starting Mileage = 88, Ending Mileage = 92, Total Mileage = 4
So EndingMileage (92) - Starting Mileage (88) = Total Mileage (4)
This works fine.

The "nonworking login form.jpg" shows:
Starting Mileage = 99, Ending Mileage = 105, Total Mileage = 0
So EndingMileage (105) - Starting Mileage (99) = Total Mileage (0)
This does NOT work.

Please help. Either vbscript or arcpad 7.1.1 thinks that the first number in
Starting Mileage (9) in the 99 value is greater than the first number in
Ending Mileage (1) in the 105 value????

I can get this formula to work if I add a 0 in front of the 99 in Starting Mileage.... so this works
Ending Mileage (105) - Starting Mileage (099) = 6, but I don't want my users
to have to put a 0 in front of a number if it was 99 miles, and then there speedometer goes
to 105 miles.....

How can I get around this issue??? Is there some script I can write in vbscript?

thank you
James Ireland
GIS Technician

Re: Subtracting two numbers in vbscript on a form

Almarde_Ronde — Thu, 15 Jul 2010 14:48:10 GMT

Just tried it out myself using a custom applet and all works well. I attached the applet, so you can see if it works for you.

Re: Subtracting two numbers in vbscript on a form

Anonymous User — Fri, 16 Jul 2010 13:33:44 GMT

Original User: coriba

I am not sure of the cause, seems funny. did you try casting the values?

result = cint(objctl1.value)-cint(objctl2.value)

Re: Subtracting two numbers in vbscript on a form

JamesIreland — Fri, 16 Jul 2010 14:15:42 GMT

yes I tried putting cInt and they didn't work either.
I forgot to mention I am using a form in a system folder
on the Arpad.apx & Arcpad.vbs
I have attached my code, not sure if it will work for you to test, but here it is:

James Ireland