Value errors occur during bulk copy transfer or destination-template transfer processing when the value being inserted has one of the following characteristics:
It cannot be converted to the target column’s datatype.
It is out of range for the target column’s datatype.
Express transfer does not support value error handling:
If an error occurs, it aborts the entire transfer.
The access service handles these errors using the following properties:
CharConvertError
NumConvertError
DatetimeConvertError
DefaultDate
DefaultTime
DefaultNum
If the SendWarningMessages property is set to yes, the access service sends a message to the client application when it encounters value errors.
In addition, the preceding properties can be used to fill in default values when datatype conversion fails during bulk copy and destination-template transfer.
For more information about configuration properties, see Chapter 2, “Configuring the Access Service Library for DirectConnect.”
For information about values that cause errors for database access service during bulk copy transfer, see Chapter 9, “Using Bulk Copy Transfer and Express Transfer.”
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
