Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TRIM with remote views
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 2000 Server
Database:
MS SQL Server
Divers
Thread ID:
01117330
Message ID:
01117334
Vues:
14
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform