Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view padding varchar inconsistency
Message
 
 
To
22/08/2006 18:57:48
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
MS SQL Server
Miscellaneous
Thread ID:
01147740
Message ID:
01147741
Views:
27
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform