Currently i got over +40 textfields which uses DML and the column is 255 VARCHAR
Wondering if there a quick way of trimming all these fields before the update happens.
As of right now im doing it like this... is there way a to grab all textfield and just loop and trim or something simliar....? i was thinking of using javascript and copy paste 40 names in an array and loop trim and set value but that seem ugly to me. as i have to go in to it every time if a new field is needed...
:P1_name := trim(:P1_name)
:P1_boat := trim(:P1_boat)
:P1_book := trim(:P1_book)
:P1_game := trim(:P1_game)
:P1_phone := trim(:P1_phone)
.
.
.
:Px_item := trim(:Px_item)
Edited by: PandaOracle on Feb 14, 2012 2:19 PM