Subject | RE: [firebird-support] Re: Absolute Mystery |
---|---|
Author | Helen Borrie |
Post date | 2005-02-16T02:28:20Z |
At 04:02 PM 15/02/2005 -0800, you wrote:
What is the source of what you refer to as "script lines"? It it an
external table?
If so, I would be considering that the discrepancy is due to some lines not
having record delimiters. This error would be trapped by your WHEN ANY
block as "one very long, illegal record" and would be written away as one
log entry - even though, according to your perception of the source data,
it involved "several lines".
Even if you are not dependent on e.g. CRLF as a record delimiter, but on
placeholders, a missing or invalid placeholder on one record could throw
hundreds out of synch, with no prediction about how they would be read,
i.e. one trapped exception could span scores or even hundreds of "source
lines".
./heLen
>That's the wierd thing here. All the exceptions are accounted for andIt can't be a "silent exception". You have this covered in your logic.
>visible. Exceptions outside the WHEN ANY DO get a global set and then
>processed, Exceptions inside the WHEN ANY DO cause a dialog box to pop up
>and pause the script. If it is an exception, then it silent for some
>reason. How can an exception be silent?
What is the source of what you refer to as "script lines"? It it an
external table?
If so, I would be considering that the discrepancy is due to some lines not
having record delimiters. This error would be trapped by your WHEN ANY
block as "one very long, illegal record" and would be written away as one
log entry - even though, according to your perception of the source data,
it involved "several lines".
Even if you are not dependent on e.g. CRLF as a record delimiter, but on
placeholders, a missing or invalid placeholder on one record could throw
hundreds out of synch, with no prediction about how they would be read,
i.e. one trapped exception could span scores or even hundreds of "source
lines".
./heLen