Help require in given scenario [message #388470] |
Tue, 24 February 2009 23:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sirfkashif
Messages: 70 Registered: September 2007 Location: Rawalpindi
|
Member |
|
|
Dear all,
I have a editor attached with a text box and i want to restrict user from using "Enter" button so that user enter data without hitting "Enter".
Urgent help is required, so any hint or help will be appreciated.
Regards,
Kashif
|
|
|
|
Re: Help require in given scenario [message #388739 is a reply to message #388470] |
Thu, 26 February 2009 00:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sirfkashif
Messages: 70 Registered: September 2007 Location: Rawalpindi
|
Member |
|
|
Dear Djmartin,
Thanks for reply. Actually the problem was that when i export that data into excel then that user pressed "Enter" on runtime editor comes into play and would create new excel cells in short excel converted report was a disaster but now i wrote the following code on post-insert trigger
update table t
set t.comments = replace(t.comments,chr(10),chr(32))
where t.table_id = :table1.table_id;
so if user even pressed "enter" on the editor
before commit all "Enter" will be replaced by "Space".
And it worked for me.
Regards,
Kashif
|
|
|
|
|