Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view padding varchar inconsistency
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Remote view padding varchar inconsistency
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Divers
Thread ID:
01147740
Message ID:
01147740
Vues:
77
Hello all,

I am finding a strange inconsistency when saving a remote view where the fields in the data source (SQL Server 2005) are varchar.

- When saving the remote view when the data is edited in the browse window, the varchars are *not* padded with trailing spaces. This is the behavior I want.

- When saving the remote view when the data is edited in a base VFP form and base VFP edit box, the varchars end up being padded to their maximum width with whitespace. The edit controls do not have any input mask.

I ensured that the view definition for the field(s) in question are actually varchar, not char. e.g.
DBSetProp(ThisView+".x_desc","Field","DataType","V(20)")

Any help is appreciated.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform