Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
>I have a 6(c) field for stock tickercode with over 9000 entries.
>Some how only the first letter of the 6 char now displays and I can not reason why.
> I did a view to see if all info was displayed, and it was. So I did a query, got all the info displayed as before, copied it to a new table, got all the info, saved it(whew),copied it to my zip, then re-entered it into the original table and got only the first letter of the 6(c) field again.
> At no time was I ever in the table designer where I could have changed any of the structure.
Any LTRIM, RTRIM, LEFT or RIGHT functions involded?
Is your table structure still the same?
Wasn't lost until you recovered the data from the new table?
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