搞笑:
一、
CREATE CURSOR test (读者证号 c(8),借阅日期 c(8),中图分类号 c(20))
INSERT INTO test VALUES ("2003001","06/12/07","tp3/123")
INSERT INTO test VALUES ("2003001","06/12/07","h1233.44/11")
INSERT INTO test VALUES ("2003001","06/12/07","tp311.1/12")
UPDATE test SET 中图分类号=justpath(中图分类号)
&&这个结果正确
二、
CREATE CURSOR test (读者证号 c(8),借阅日期 c(8),中图分类号 c(20))
INSERT INTO test VALUES ("2003001","06/12/07","tp3/123")
INSERT INTO test VALUES ("2003001","06/12/07","h1233.44/11")
INSERT INTO test VALUES ("2003001","06/12/07","tp311.1/12")
select 读者证号,justpath(中图分类号) as flh from
test &&这个结果不对
什么原因???