removed the use part of the proceedure
moved sql transactions
made sql query generation easier to update
added transactions for equip and next of kin
change precision of property
properties being assigned incorrectly
fixing datatypes
convert decimal to ft and back
changing datatype of height and weight to decimal