Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
Error Message 700 .. is long |
Tue, Sep 8 2009 12:14 PM | Permanent Link |
"Malcolm" | 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> -- |
Tue, Sep 8 2009 12:36 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Tue, Sep 8 2009 1:01 PM | Permanent Link |
"Malcolm" | 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> -- |
Wed, Sep 9 2009 5:52 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Sep 10 2009 2:58 PM | Permanent Link |
"Malcolm" | PS: Mathias has agreed to add handling of longer messages to his
ToDo list. -- |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |