各位老大们,小弟这用PB建了一个表,
SELECT "CARDSALEDETAIL"."CSDNO",
"CARDSALEDETAIL"."CSDRONUM",
"CARDSALEDETAIL"."CSDTYPE",
"CARDSALEDETAIL"."CSDNO1",
"CARDSALEDETAIL"."CSDNO2",
"CARDSALEDETAIL"."CSDNO3",
"CARDSALEDETAIL"."CSDTOTMONEY",
"CARDSALEDETAIL"."CSDMONEY",
"CARDSALEDETAIL"."CSDTOTZK",
"CARDSALEDETAIL"."CSDZK",
"CARDSALEDETAIL"."CSDLB"
FROM "CARDSALEDETAIL"
WHERE ( csdno = :vseqno )
CSDNO3这个键值是数值型允许手工输入的,现在想限制这个键值的长度,比如就让他输入4位数,或者输入多了就取前四位,这个该怎么改啊
SELECT "CARDSALEDETAIL"."CSDNO",
"CARDSALEDETAIL"."CSDRONUM",
"CARDSALEDETAIL"."CSDTYPE",
"CARDSALEDETAIL"."CSDNO1",
"CARDSALEDETAIL"."CSDNO2",
"CARDSALEDETAIL"."CSDNO3",
"CARDSALEDETAIL"."CSDTOTMONEY",
"CARDSALEDETAIL"."CSDMONEY",
"CARDSALEDETAIL"."CSDTOTZK",
"CARDSALEDETAIL"."CSDZK",
"CARDSALEDETAIL"."CSDLB"
FROM "CARDSALEDETAIL"
WHERE ( csdno = :vseqno )
CSDNO3这个键值是数值型允许手工输入的,现在想限制这个键值的长度,比如就让他输入4位数,或者输入多了就取前四位,这个该怎么改啊
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货