Dear all,

Even though I set PreparedEdits to false, the Query still prepare the
update statement before executing it. From the Help, it said:

"This property determines whether all updates are performed through a
prepared DSQL statement or whether a DSQL statement for just the
updated columns should be constructed and immediately executed (the
default)."

It seems I cannot make it just construct a DSQL statement and execute
immediately.

My log:
20/2/2003 17:55:29 - /*---
PREPARE STATEMENT
TR_HANDLE = 12146316
STMT_HANDLE = 12145932

UPDATE BRAND SET
ID = ? /* ID */ , /*PK*/
NAME = ? /* NAME */
WHERE
ID = ? /* OLD_ID */

PLAN (BRAND INDEX (RDB$PRIMARY3))

FIELDS = [ Version 1 SQLd 0 SQLn 30 ]
----*/
20/2/2003 17:55:35 - /*---
EXECUTE STATEMENT
TR_HANDLE = 12146316
STMT_HANDLE = 12145932
PARAMS = [ Version 1 SQLd 3 SQLn 3
[ID] = 226
[NAME] = 'NEW3'
[OLD_ID] = 226 ]

SELECT COUNT: 1
UPDATE COUNT: 1

SECONDS = 0.010
----*/

Please help.

Thanks.
Michael