看看这段程序，帮我找找问题？

[anywnldh]

SELECT A
USE cj2004b541
DO WHILE NOT EOF()
IF cjj = "E" THEN
UPDATE cj2004b541 SET pore = "优秀"
ELSE
IF cjj = "P" THEN
UPDATE cj2004b541 SET pore = "合格"
ENDIF
ENDIF
SKIP
ENDDO
USE
结果是pore字段中的内容都是“合格”
即使cjj的内容为"E"的字段

[fcb]

SELECT A
USE cj2004b541

UPDATE cj2004b541 SET pore = "优秀" WHERE cjj="E"
UPDATE cj2004b541 SET pore = "合格" WHERE cjj="P"

USE

不用DO While就可以了

[十豆三]

SELECT A
USE cj2004b541

也可以省略！

[十豆三]

即：

UPDATE cj2004b541 SET pore = "优秀" WHERE cjj="E" &&替换
UPDATE cj2004b541 SET pore = "合格" WHERE cjj="P" &&替换
use in cj2004b541 &&关闭表

[十豆三]

SELECT A
USE cj2004b541
DO WHILE NOT EOF()
IF cjj = "E" THEN
replace pore WITH "优秀"
ELSE
IF cjj = "P" THEN
replace pore WITH "合格"
ENDIF
ENDIF
SKIP
ENDDO
USE

[十豆三]

UPDATE - SQL 命令

如果省略了 WHERE 子句，在列中的每一行都用相同的值更新。
---------------------------------------------------------
用上面的方法，或者改为下面两句即可：

UPDATE cj2004b541 SET pore = "优秀" WHERE cjj="E"
UPDATE cj2004b541 SET pore = "合格" WHERE cjj="P"