Knowledge base: Apia 
|
Language: English
|
History
|
 |
|
 |
|
|
|
|
[ AHF00113 ] Possibility of performing user's queries where a business class specifies the SQL sentence to execute
Summary
When updating Apia to one of the releases here mentioned, the following SQL sentences must be executed. These will allow to create user's queries where a business class specifies the SQL sentence to return data.
It is applied to
Solution
The following sql sentences must be executed: insert into event (evt_id_auto,evt_name,evt_scope,evt_desc) values (39,'ONBEFOREGETSQL','Q','Query before get SQL'); DELETE FROM LABELS where LBL_SET_ID=1 and LANG_ID < 1000 and LBL_ID in ('lblQryEvtBeforeGetSQL'); INSERT INTO LABELS (LBL_SET_ID, LANG_ID, LBL_ID, LBL_NAME, LBL_TOOL_TIP, LBL_ACCESS_KEY, LBL_DESC, REG_USER, REG_STATUS) VALUES( 1, 1, ' lblQryEvtBeforeGetSQL ', 'onBeforeExecuteSQL', '', '', '', 'admin', 0); INSERT INTO LABELS (LBL_SET_ID, LANG_ID, LBL_ID, LBL_NAME, LBL_TOOL_TIP, LBL_ACCESS_KEY, LBL_DESC, REG_USER, REG_STATUS) VALUES( 1, 2, ' lblQryEvtBeforeGetSQL ', 'onBeforeExecuteSQL', '', '', '', 'admin', 0); INSERT INTO LABELS (LBL_SET_ID, LANG_ID, LBL_ID, LBL_NAME, LBL_TOOL_TIP, LBL_ACCESS_KEY, LBL_DESC, REG_USER, REG_STATUS) VALUES( 1, 3, ' lblQryEvtBeforeGetSQL ', 'onBeforeExecuteSQL', '', '', '', 'admin', 0); Related from
Suggested items
|
|
