key_next_item trigger [message #593924] |
Thu, 22 August 2013 01:12 |
|
furqan
Messages: 115 Registered: January 2012 Location: Hyderabad
|
Senior Member |
|
|
hello sir,
i have KEY_NEXT_ITEM trigger on my text item.
its working fine fine but the only problem is,
if the value in the text item is numeric it working fine but
if its alpha numeric(alphabets + numbers) it needs single quotes
to be added to the value.want to avoid putting single quotes around
the values.please help.
code in trigger is..as follows.
if :text_item89 is not null and :text_item89='REMARKS' then
set_block_property('LOC_MSTR',default_where,'REMARKS='||:text_item88);
go_block('LOC_MSTR');
execute_query;
END IF;
|
|
|
|
|
|
|
|
|
|
|
|
|
|