2014年7月1日 星期二

IDempiere AD_Tab_Customization User 客製化後新增欄位無法同步 GridField 顯示內容

IDempiere AD_Tab_Customization User 客製化後新增欄位無法同步 GridField 顯示內容

SELECT * FROMadempiere.AD_Tab_Customization where AD_Tab_ID=1000061
DELETE from adempiere.AD_Tab_Customization where AD_Tab_ID=1000061


select * from adempiere.AD_Tab_Customization where AD_Tab_ID=1000061
DELETE from adempiere.AD_Tab_Customization where AD_Tab_ID=1000061


CREATE OR REPLACE FUNCTION adempiere.AD_Field_trigger_f()
  RETURNS trigger AS
$BODY$
BEGIN
  IF NEW.AD_Tab_ID IS NOT NULL THEN
     DELETE FROM AD_Tab_Customization WHERE AD_Tab_ID=NEW.AD_Tab_ID;
  END IF;
  RETURN NEW;
END$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100;
ALTER FUNCTION adempiere.AD_Field_trigger_f()
  OWNER TO postgres;

DROP TRIGGER AD_Field_trigger ON  adempiere.AD_Field

CREATE TRIGGER AD_Field_trigger
  AFTER INSERT OR UPDATE OF SEQNO,SEQNOGRID
  ON adempiere.AD_Field
  FOR EACH ROW
  EXECUTE PROCEDURE adempiere.AD_Field_trigger_f();

沒有留言:

張貼留言