1、TOraQuery的更新,默认是只读,需要UpdateObject,配合TOraUpdateSQL设计更新插入删除的sql 类似
INSERT INTO dc_formtype
(FORMTYPEID, FORMTYPENAME, SENIORFORMTYPEID, DESCRIPTION, SHOWORDER)
VALUES
(:FORMTYPEID, :FORMTYPENAME, :SENIORFORMTYPEID, :DESCRIPTION, :SHOWORDER)
UPDATE dc_formtype
SET
FORMTYPEID = :FORMTYPEID,
FORMTYPENAME = :FORMTYPENAME,
SENIORFORMTYPEID = :SENIORFORMTYPEID,
DESCRIPTION = :DESCRIPTION,
SHOWORDER = :SHOWORDER
WHERE
FORMTYPEID = :OLD_FORMTYPEID
DELETE FROM dc_formtype
WHERE
FORMTYPEID = :FORMTYPEID
这些sql都可以自动产生