Help! I ahve a file that I am getting an error 205 on select. I know the field and the value that is in the field but I can't fix the error because as soon as I try to access the record I get the error 205 message. I have tried to export the table but then I get a read error message at that point. The check table function does not report any errors and I am leary of using the rebuild function as I know it will export, drop the table am rebuild the data but with the error it will only post part of the data.

Any suggestions would be most appreciated!

Thanks,
J.C>

Other options for viewing the data are qptool (ex. qptool6.2 -c999 -q'select * from ttaad100') or using Oracle select via SQL*plus or similar tool. Check your error log files for indications as to what data is out of range. If you are worried about the data, back it up via bdbpre6.2 before using the bdbreconfig to export (to R. file), drop, create, and import the table.

Can you post the error bw screen ....

Can you post the error bw screen ....

If you know the record and the field that is out of the range defined by it's domain, you should be able to correct it with ttaad4100, no?

Uli

Access the errorneous same through oracle and correct the same through oracle to make it in range with baan domains . Then u wont get error 205.