Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Michael,
The view definition contains the length of a char() column. It may not be long enough.
>OK, now this one is strange:
>
>When I do a view to a SQL table the view is not giving me the last character in one of fields.
>
>I believe that character is in the database, because my query is against that field and it pulls up the record if I include that character, and does not pull it up if I don't.
>
>So: The field contains a string like this: GG-12121A
>
>If I query against that field using a view and ask for GG-12121A, it finds the record but the result table contains GG-12121
>
>If I search for GG-12121 (without the A), then no matches are found.
>
>Help!
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