Housemartins
IS-IT--Management
The question starts from a security issue. The well known job P0011 contains the UDC with the alias ICUT which is responsible for the Batch Type selection.I would like to lock that UDC in order to prevent some users from selecting other types than "T" (Equipment Time Entry). I realized that the specific fields is the alias KY on F0005 table.Thus,using the utb, I tried to find the value "T".Amazingly I descovered that the value "T" was not there....strange...uh? Well, having searched the database through SQL query analyser I found out that the field is char(10) and the specific value had 8 spaces at the front!!!And the question is....WHY??? In an advanced search I found out that the specific fields contain values of many forms...with no spaces at the front,with 7 spaces,with 9 spaces.Having found that, I tried to find it through utb by adding 8 spaces at the front,but nothing!After one hour,luckily I managed to find it.I had to search it using the string "________T*"....Superb!I would be greatful if I could hear a logical explanation for this and in addition any ideas about how to secure this field as long as it can find the wanted value.
Thanks in advance.
Thanks in advance.