I love what you do for all of us, Thank You.
I am working on a android app, I have a database that has a case_qty column a case_cost column and a cost column, can sql do
case_cost / case_qty and put the answer in cost when the record is being added?
Post a Reply
|Oldest Newest Rating|
· January 12, 2015
You should be able to do
update your_table set cost = (case_cost / case_qty) where your_where_clause
· January 13, 2015
Thank you both for your input, all this is new to me,
I guess I would need to do a function that gets the information
and then call that function in the update statement?
Java / Android Development
Very popular language used to create desktop applications, website applets, and Android apps.
|Bucky Roberts Administrator|