From b5b3013cf029f24459e22b2c6db0e8349ba43f4c Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期一, 12 十二月 2022 17:28:58 +0800
Subject: [PATCH] 1

---
 data/db_fn.sql |    6 ++----
 1 files changed, 2 insertions(+), 4 deletions(-)

diff --git a/data/db_fn.sql b/data/db_fn.sql
index 29f36ed..910b860 100644
--- a/data/db_fn.sql
+++ b/data/db_fn.sql
@@ -359,15 +359,13 @@
 select gb,name,classes,pinyin,pac,bsm,geom,eventid,dirid,depid,verid,createtime,createuser,updateuser,updatetime from bd.dlg_agnp
 
 select * from bs.bs_project;
-
 select * from bd.dlg_agnp order by gid desc;
 insert into bd.dlg_agnp(gb,name) values('01','A01');
 insert into bd.dlg_agnp(gb,name) values('02','A02');
 select * from lf.sys_dict where ns='bs' and tab='bs_project';
 
-
-
-
+select fn_rec_query(depid,'dep') depName,fn_rec_query(dirid,'dir') dirName,fn_ver(verid) verName,
+  fn_uname(createuser) createName,fn_uname(updateuser) updateName from bd.dlg_agnp limit 10;
 
 
 

--
Gitblit v1.9.3