Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TRIM with remote views
Message
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01117330
Message ID:
01117334
Views:
13
This message has been marked as the solution to the initial question of the thread.
>Hi all,
>
>I have a remote view to a table on SQL with a field 250 chr long
>
>when I do some thing like this:
>
>
>replace veiw.field with "ABC"
>tableupdate(.t.)
>
>
>the result on the SQL table is
>
>
>table.field = "ABC                            "
>
>
>how do I send an update i a way that no extra spaces are added to the end result?
>
>Thanks

You'd have to define your view to use a varchar field.

Also take a look at the help for SET VARCHARMAPPING ON.
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform