Trapping Error 6174 - Numeric Type Overflow

[ChezJfrey]

I am using a Dataserver to connect to an SQL database and using the BUFFER-COPY statement to transfer a record from the Progress db to the SQL db. I received error 6174 because the SQL db was migrated from the Progress definitions and a field contains a decimal value that exceeds the defined format. I located the field, changed the precision in the SQL db, updated
the schema holder and all is well.

How does one trap this error? The program execution terminated on this line, but I would like to log the error and continue. Should I use another technique to copy the data to the SQL db?

Just in case it matters: Progress 9.1C15, Win2k, SQL 2000

 

[cecsno]

Use the no-error option on buffer-copy, the check the error-status system handle

IF ERROR-STATUS:ERROR
then do:
disp stream err-stream "error info"
end.

 

[ChezJfrey]

Sorry, I wasn't explicit - the NO-ERROR statement does not allow the program to continue, it still terminates on the BUFFER-COPY statement.