Navigation

Changeset 17861

Timestamp:

08/08/08 11:35:58 (1 month ago)

Author:

puno

Message:

Sample for updating existing property added.

Files:

r17856	r17861
5	5	prompt Loading PN_PROPERTY...
6	6
7		-- sample record
	7	-- sample insert record
8	8	-- insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
9	9	-- values (2000, 'en', 'text', 'some.key.value', 'Some property value', 'A', 0, 1, null);
10	10	-- here add new properties
	11
	12	-- sample update of existing record
	13	-- update pn_property p set
	14	-- p.property_type = 'some property type to set',
	15	-- p.property_value = 'some property_value to set',
	16	-- p.record_status = 'some record status',
	17	-- p.is_system_property = some_system_property,
	18	-- p.is_translatable_property = some_translatable_property,
	19	-- p.property_value_clob = 'some property value clob'
	20	-- where
	21	-- p.context_id=2000 and
	22	-- p.language = 'en' and
	23	-- p.property = 'prm.workflow.envelope.abort.label'
	24	-- values under apostrophes are VARCHAR2 and without are NUMBER type so please pay attention
	25	-- please in UPDATE caluse use only those columns you want to update and not all of them
	26	-- usual column for update will be property_value where property value resides
	27
	28
11	29	insert into PN_PROPERTY (CONTEXT_ID, LANGUAGE, PROPERTY_TYPE, PROPERTY, PROPERTY_VALUE, RECORD_STATUS, IS_SYSTEM_PROPERTY, IS_TRANSLATABLE_PROPERTY, PROPERTY_VALUE_CLOB)
12	30	values (2000, 'en', 'text', 'prm.schedule.main.view.option.indented.ajax.name', 'Indented (Beta)', 'A', 0, 1, null);