Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Mark,
The situation is basically that Select will take the length of the *first* field returned and use that length for the field for all subsequent records returned. So that even with a simple thing like ...IIF(x > y, "NO", "YES"), if the first result is a "NO" then any yeses will appear as "YE". So it is always safest to either make sure that any function always returns information of identical length *or* to adjust the returned value (using PADx or 001.000(as many zeroes as needed)*result). In the example above I would code "NO " to cover this.
Cheers,
Jim N
>>Just a word of caution that you can/will have the same problem with character
>>fields, given the right circumstances.
>
>As a result of this I went back and looked at a few functions that return character data to a SELECT, but they all seem to work. What "circumstances" might cause a problem like you mention with character data?
>
>>And when the boss asks, tell him that you still don't know everything yet,
>>but you continue to work on exactly that.
>
>Some bosses seem to expect perfection! I often wonder when was the last time they looked in the mirror??? :)
>
>Thanks Jim
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement