Thank you Jason,
I commented out the echo($WA_Sql); and tested the page and it updates the table OK.
I have one more problem with the page and that is with the selection of the currency field str_currency. In the DB table the field is a varchar length 50
At the moment the field is inserted with a 0 (zero)
I think I have the settings correct and cannot see why a zero should be entered in place of a string.
Can you see what may be incorrect please?