增加一个函数:
function fReadMoreValueFromDBBySQL(sSQL:string;sRowSepStr:string;sColSepStr:string;sLenSetStr:string):string;
sSQL: 表示SQL语句
sRowSepStr: 行分隔符, 一般可以输入 CHR(13)
sColSepStr: 列分隔符, 一般可以输入 ','
sLenSetStr: 列字符宽度设置, 如: '30,5,50,20',
注意,如果参数sLenSetStr为空,则每行紧凑显示;
如果随便输入一些字符,如'AA',则将智能采用该数据集中该列的最长值的长度.
例如:
1>.(下列"'S E LECT ",由于论坛字符限制, 实际使用中,要去掉中间的两个空格)
[fReadMoreValueFromDBBySQL('S E LECT TOP 20 PO_NBR,LINE,ITEM_CODE,QTY FROM PO_D',CHR(13),',','30,5,50,20')]
结果如下:
PO100300002 , 1,210-000001 , 5000
PO100300003 , 1,215-000001 , 6000
PO100300004 , 1,216-000001 , 3000
PO100300005 , 1,210-000001 , 3000
PO100300006 , 1,226-000001 , 4000
PO100300007 , 1,215-000001 , 2000
PO100300007 , 2,215-000002 , 2000
PO100300007 , 3,215-000003 , 2000
PO100300007 , 4,215-000004 , 2000
PO100300007 , 5,215-000005 , 2000
PO100300008 , 1,241-000001 , 50000
PO100300008 , 2,242-000001 , 5
PO100300008 , 3,232-000001 , 5
PO100300009 , 1,221-000001 , 200
PO100300009 , 2,222-000001 , 2000
PO100300009 , 3,227-000001 , 2500
PO100300010 , 1,261-000001 , 10000
PO100300010 , 2,262-000001 , 5000
PO100300011 , 1,223-000001 , 500
PO100300011 , 2,224-000001 , 2000
2>.(下列"'S E LECT ",由于论坛字符限制, 实际使用中,要去掉中间的两个空格)
[fReadMoreValueFromDBBySQL('S E LECT TOP 20 PO_NBR,LINE,ITEM_CODE,QTY FROM PO_D',CHR(13),',','AA')]
结果如下:
PO100300002 , 1,210-000001 , 5000
PO100300003 , 1,215-000001 , 6000
PO100300004 , 1,216-000001 , 3000
PO100300005 , 1,210-000001 , 3000
PO100300006 , 1,226-000001 , 4000
PO100300007 , 1,215-000001 , 2000
PO100300007 , 2,215-000002 , 2000
PO100300007 , 3,215-000003 , 2000
PO100300007 , 4,215-000004 , 2000
PO100300007 , 5,215-000005 , 2000
PO100300008 , 1,241-000001 , 50000
PO100300008 , 2,242-000001 , 5
PO100300008 , 3,232-000001 , 5
PO100300009 , 1,221-000001 , 200
PO100300009 , 2,222-000001 , 2000
PO100300009 , 3,227-000001 , 2500
PO100300010 , 1,261-000001 , 10000
PO100300010 , 2,262-000001 , 5000
PO100300011 , 1,223-000001 , 500
PO100300011 , 2,224-000001 , 2000
3>.(下列"'S E LECT ",由于论坛字符限制, 实际使用中,要去掉中间的两个空格)
[fReadMoreValueFromDBBySQL('S E LECT TOP 5 PO_NBR FROM PO_M',',',',','')]
结果如下:
PO100300002,PO100300003,PO100300004,PO100300005,PO100300006
[帖子最后于:2013/3/20 12:16:46 被 E树软件 编辑过]