Disable auto removing spaces from text-fields in Oracle Forms 4.5
885756Sep 1 2011 — edited Jun 15 2013Hi everybody!
Its my first post here, and i hope that somebody could answer for my question :)
I'm making search form (kind of filtering table) in Oracle Forms 4.5
Its based on one table and text fields to enter some data. Lets say that data to enter in this text field is "name and surname".
While entering these information every 500ms timer is firing and re-query (filters) table by information entered so far.
Everything works fine until the moment when user have to input a space dividing name & surname ex. "Jeff Long". Entering "Jeff" filters table to every guy that has name "Jeff" but it impossible to enter "Jeff ". Oracle automatically deletes space after "Jeff " every time trigger fires. Workaround is to enter "Jeff_" or fast enough (<500ms) "Jeff L" in order to have space between some letters. Other option is to divide name and surname into 2 different text fields. But is there an option to force Forms not to rtrim values in text-fields or some other workarounds?
Thanks in advice.