Hi Tim, you may not want to do anything about this .. but ..

It is nice to have full and informative messages but today I got
caught with a series of #700s and they are too long for MadExcept.

So I was getting
  "<snip> .. expected <a long list of types> but inste<clipped>"
and missing the interesting (to me) bit at the end!

I don't have an actual example now (all sorted) so I am not sure
*exactly* where the message was being clipped but it was a little
inconvenient.

Just wondering if we need the full list of types or whether a shorter
'sample' list would be just as informative? <gdr>

--

Malcolm,

<< Just wondering if we need the full list of types or whether a shorter
'sample' list would be just as informative? <gdr> >>

Well, the issue is that we'll miss the one type that somebody actually
needs, and then they'll come for our heads when they realize that we
intentionally left it out.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Malcolm,
>
> Well, the issue is that we'll miss the one type that somebody
> actually needs, and then they'll come for our heads when they
> realize that we intentionally left it out.

Hmm, so the list is built in the context of the particular statement?
It seems I had it completely at a loss over what to expect! <bg>
<shrug>
--

Malcolm,

<< Hmm, so the list is built in the context of the particular statement? >>

Yes, it is built in terms of what the compiler expects as a valid type in
the context of where it is being used.  For example, if you have this
condition:

MyColumn=100

and MyColumn is a VARCHAR, then the error message will indicate all of the
data types that are compatible with a VARCHAR and could be used instead of
the 100 INTEGER value, which is obviously invalid.

<< It seems I had it completely at a loss over what to expect! <bg> >>

 Some types are compatible with a very long list of other types, so the
list is just long.  The INTERVAL types don't help matters much, since there
are a lot of them.

--
Tim Young
Elevate Software
www.elevatesoft.com

PS:  Mathias has agreed to add handling of longer messages to his
ToDo list.

--