Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote view padding varchar inconsistency
Message
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
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:
01147741
Vues:
19
This message has been marked as the solution to the initial question of the thread.
It's documented in the help under Format Property that in order to prevent padding for Varchar fields, you have to set following properties of a textbox
.Format = "F"
.MaxLength = <Max # of characters>
>
>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)")
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform