[mhk] r1099 committed - Fixes problem with generating new rpersons ids

1 view
Skip to first unread message

codesite...@google.com

unread,
Apr 17, 2015, 12:37:25 PM4/17/15
to mhk-dis...@googlegroups.com
Revision: 1099
Author: joaquim....@gmail.com
Date: Fri Apr 17 16:37:10 2015 UTC
Log: Fixes problem with generating new rpersons ids
https://code.google.com/p/mhk/source/detail?r=1099

Modified:
/trunk/idb/etc/db/system/record_linking/rentities.sql

=======================================
--- /trunk/idb/etc/db/system/record_linking/rentities.sql Mon Nov 29
18:12:47 2010 UTC
+++ /trunk/idb/etc/db/system/record_linking/rentities.sql Fri Apr 17
16:37:10 2015 UTC
@@ -16,7 +16,7 @@
vobs TEXT,
OUT vid VARCHAR(64))
BEGIN
- insert into rpersons (sname,sex,status,obs)
VALUES(vsname,vsex,vstatus,vobs);
+ insert into rpersons (id,sname,sex,status,obs)
VALUES('**fake_ID**',vsname,vsex,vstatus,vobs);
SET vid:=concat('rp-',LAST_INSERT_ID());
update rpersons set id=vid where seq=LAST_INSERT_ID();
insert into rentities (id,the_class, description, status,user,obs)
Reply all
Reply to author
Forward
0 new messages