Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why does VFP fill Oracle 7 fields up with spaces?
Message
De
27/11/1996 18:18:45
Jason Jones
Bowne of Los Angeles, Inc.
Los Angeles, Californie, États-Unis
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Why does VFP fill Oracle 7 fields up with spaces?
Divers
Thread ID:
00013752
Message ID:
00013752
Vues:
74
In VFP 3.0, if I create an updateable view and add a record containing a character field, and the character data for that field is less than the maximum field width, the value added is padded right with spaces so it fills up the column. Why?

If I use SQLPassthough, this doesn't happen.

For Example: If I add "WO" to a batch_type field defined as varchar2(8), what gets added to the table is
WO ", NOT "WO".
Répondre
Fil
Voir

Click here to load this message in the networking platform