Suppose you have a table with a 15 char text field if you try to add a
record (using an APPEND query) that puts more than 15 chars to that
field. An exception will be generated. Shouldn't EDB just truncate the
text instead of raising an exception? Thats what happens when you use
AppendRecord instead of an APPEND query.

Michael,

<< Suppose you have a table with a 15 char text field if you try to add a
record (using an APPEND query) that puts more than 15 chars to that field.
An exception will be generated. Shouldn't EDB just truncate the text instead
of raising an exception? >>

No, according to the SQL 2003 standard, any time a value assignment is
truncated or out of range, an exception or warning should be raised.

<< Thats what happens when you use AppendRecord instead of an APPEND query.
>>

AppendRecord calls the same internal functionality to set the field values,
so it should also raise an error.

--
Tim Young
Elevate Software
www.elevatesoft.com