DELPHI支持的SQL中如何实现对数据库的批处理或建立一个SQL过程?(50分)

在一表中我想根据某一字段的变化来确定另一字段的值.于是在QUERY.SQL中用IF...THEN
UPDATE..SET..ELSIF.. ENDIF,执行EXECSQL系统显示"无效的IF"

正确的格式是
IF Boolean_expression
{ sql_statement | statement_block }
[ ELSE
{ sql_statement | statement_block } ]

例如：
IF (SELECT AVG(price) FROM titles WHERE type = 'mod_cook') < $15
BEGIN
PRINT 'The following titles are excellent mod_cook books:'
PRINT ' '
SELECT SUBSTRING(title, 1, 35) AS Title
FROM titles
WHERE type = 'mod_cook'
END
ELSE
PRINT 'Average title price is more than $15.'

去深度立宪找一个 SQL SCRIPT 控件，很不错的

delphi的sql是依据具体的后台数据库.

接受答案了.

谢谢老千和CJ