Accidentally cc-ed ledger-smb-devel-*request*... forwarding.
---------- Forwarded message ---------- From: Erik Huelsmann <[email protected]> Date: Tue, May 17, 2011 at 11:31 PM Subject: Patch for admin.sql : admin__save_user() To: [email protected] Cc: [email protected] Hi Chris, How about this patch to admin__save_user() to fix the issue that the admin must be in the employee table too. Index: sql/modules/admin.sql =================================================================== --- sql/modules/admin.sql (revision 3137) +++ sql/modules/admin.sql (working copy) @@ -358,6 +358,11 @@ insert into user_preference (id) values (v_user_id); + select * from entity_employee where entity_id = in_entity_id; + IF NOT FOUND THEN + select into entity_employee (entity_id) values (in_entity_id); + END IF; + -- Finally, issue the create user statement return v_user_id ; Bye, Erik. ------------------------------------------------------------------------------ What Every C/C++ and Fortran developer Should Know! Read this article and learn how Intel has extended the reach of its next-generation tools to help Windows* and Linux* C/C++ and Fortran developers boost performance applications - including clusters. http://p.sf.net/sfu/intel-dev2devmay _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
