Invalid character value for cast specification Error

[princessk1]

I have created a text file to import into a table. The following error occurs during the import:
"Invalid character value for cast specification". Does anyone know what this means? Thanks.

 

[tlbroadbent]

It would be helpful to know the database you use, the version, the method of import, etc. Got more details for us?

Typically, this error means the import process is trying to convert (cast) a value in the text file from a character data type to another data type such as numeric or datetime and the value in the text file is not valid for the new data type. Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[bms1]

I am getting the same error and I am using Clarion to access an SQL database. I get the error the first time I try to access the file but then when I click again to access the file the second time I do not get the error. Do you know what can be done to prevent this error?