[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r5452 - phpcompta/trunk/sql
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r5452 - phpcompta/trunk/sql |
Date: |
Tue, 1 Oct 2013 17:18:09 +0200 (CEST) |
Author: danydb
Date: 2013-10-01 17:18:09 +0200 (Tue, 01 Oct 2013)
New Revision: 5452
Modified:
phpcompta/trunk/sql/upgrade.sql
Log:
Add limit op_predef.od_description
Modified: phpcompta/trunk/sql/upgrade.sql
===================================================================
--- phpcompta/trunk/sql/upgrade.sql 2013-10-01 14:12:44 UTC (rev 5451)
+++ phpcompta/trunk/sql/upgrade.sql 2013-10-01 15:18:09 UTC (rev 5452)
@@ -261,3 +261,18 @@
$BODY$
LANGUAGE plpgsql VOLATILE
+create or replace function comptaproc.opd_limit_description()
+returns trigger
+as
+$BEGIN$
+ declare
+ sDescription text;
+ begin
+ sDescription := NEW.od_description;
+ NEW.od_description := substr(sDescription,1,80);
+ return NEW;
+ end;
+$BEGIN$
+LANGUAGE plpgsql;
+
+create trigger opd_limit_description before update or insert on op_predef
execute procedure for each row comptaproc.opd_limit_description();
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r5452 - phpcompta/trunk/sql,
phpcompta-dev <=