because every time timer is triggering, Oracle Forms is leaving the field we are talking about, and trims it from spaces.Yes, this is an annoying limitation of Timers; which begs the question "Why do you need to use a Timer?" It sounds like you are trying to implement some type of auto-reducing list as the user types their search criteria. Given the fact that you are using Oracle Forms 4.5, I would recommend you simply let the user enter their search criterea and then have them click a search button or use the default functionality of Enter Query mode and Execute Query (F7 and F8 if I remember correctly).
is it clear now?Very clear! I've run into this very issue myself. It forced me to question whether I needed the Timer or not and if yes, to question if I had the delay set appropriatly. Perhaps a 500 millisecond delay is too short and your users need more time to enter their search criteria?
here is the complete solution - find the attachment
here i've done auto complete lov like google search hint
using oracle 6i........ and 10g database
its also possible in 10g developer suite