I am using Advanced Revelation version 2.1. A record was created and now results in the following error when trying to retrieve it:

'ET' Line 1. B16 Non-numeric data when numeric required. Zero used.

Line 1 'ET' broke because a run time error was encountered.

I am unable to delete this record to recreate it. I have tried Alt-D Alt-D, Recordcopy, and Ctl-D to delete the line in Edit. All attempts result in the error above. Any other suggestions?

I assume that 'ET' is an in-house program. It looks like the data that is being sent to the 'ET' program isn't being sent in the correct order or format. I would look at the data coming into the program as the problem. I wouldn't try to remove the first line of the 'ET' program. I would assume that the problem is actually in the routine that calls 'ET', especially since at line 1, 'ET' really hasn't had time to do anything.

I would suggest that you find the program that is calling 'ET' and add a DEBUG statement right before the call to 'ET'. When you break to the Debugger, check the variables that will be sent to 'ET' to make sure that they are what you expect them to be.

You didn't mention if you get the error message on the very first data row that is sent to 'ET' or it has processed some data rows before it breaks. If it breaks on the very first row it tries to process then it's maybe bad data in the row or the process that calls 'ET' isn't processing the data correctly and sending it bad data. If it has run thru one or more rows of data before breaking then it would appear to be bad data, which would require you to find the row it's breaking on so you can correct the data.

I hope this helps,

Michael Slack

View this thread on the forum...