update field (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

box -> update field (1/22/2008 3:26:38)

Hi, I want to update a field "number" with a form! let me expalin, lets say the value of the field is 8, if I insert number 2 the new value should be number 6! not to 2 nor 10, is like inventory system. is like this:

New field value = current field value - form value.

fp_sQry="UPDATE DISTINCTROW mytable SET myfield_value =('::myfield_value::'- from_value) WHERE ID= ::ID::"

Any idea please.



Spooky -> RE: update field (1/22/2008 14:19:50)

You should be able to do something like this :

fp_sQry="UPDATE mytable SET myfield_value=myfield_value - ::new_value:: WHERE ID= ::ID::"

Note - you dont use apostrophes for numeric fields



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.03125