Information générale
Titre:
SQL Server trailing spaces in RV?
I was curious if you ever ran into a situation where a VFP 7 Remote view always pads the end of a string with spaces? That is say I have a VARCHAR(30) on SQL Server and pull down a row of data that contains 'Pen' - or 3 characters of
data. If this data is pushed back (saved) from VFP 7 to SQL Server 2000 it is going in as
'Pen' + SPACE(27) instead of just 'Pen' - no trailing spaces.
Of course, this defeats the purpose of a VARCHAR. Is there a way to make the VFP remote views work without adding the trailing spaces?
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