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();
沒有留言:
張貼留言