＊＊＊＊＊＊＊＊＊＊＊
CREATE CURSOR TEM(编号 C(10),发生量 C(10))
APPEND BLANK
REPLACE TEM.编号 WITH "003",TEM.发生量 WITH "69"
ALTER TABLE TEM ADD 单价 F(12,2)

UPDATE TEM SET 单价=VAL(发生量)

SELECT 单价,编号 FROM TEM INTO CURSOR ABC READWRITE

SELECT DISTINC 编号 FROM ABC INTO CURSOR TEM READWRITE        &&出错：别名已被使用

＊＊＊＊＊＊＊＊＊＊＊

运行最后一句出错：别名已被使用，是什么原因呢　？

select-sql 好象每次都重建个数据库，不管之前是否存在

临时表的关闭等于删除

CREATE CURSOR TEM(编号 C(10),发生量 C(10))
APPEND BLANK
REPLACE TEM.编号 WITH "003",TEM.发生量 WITH "69"
*

*UPDATE TEM SET 单价=VAL(发生量)

SELECT * FROM TEM INTO CURSOR ABC readwrite

SELECT DISTINC 编号 FROM ABC INTO CURSOR TEM READWRITE        &&出错：别名已被使用


**********************************

改成这样，通过了。之前的问题出现在　ALTER TABLE TEM ADD 单价 F(12,2)　这一句，为什么呢？