Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Chr(13) in Memo fields being redefined in query?
Message
De
07/03/2012 15:05:50
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Chr(13) in Memo fields being redefined in query?
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows 7
Divers
Thread ID:
01537537
Message ID:
01537537
Vues:
86
Hello all

I have a Memo field, which is set up with Chr(13)'s to denote paragraph breaks. After running an SQL and pulling this memo field, the Chr(13) is being replace with about 200 spaces?
Instead of seeing

"The Shakers were a religious sect established in the United States in the late 1700s. They were so called because their religious rituals included shaking, shouting, dancing, whirling and singing "in tongues." They lived in communal settlements where they practiced celibacy and were known for their industry, ingenuity, and craftsmanship. By 1960, the sect had largely died out.
{Chr(13)}
According to this paragraph, _____."

I'm seeing:
The Shakers were a religious sect established in the United States in the late 1700s. They were so called because their religious rituals included shaking, shouting, dancing, whirling and singing "in tongues." They lived in communal settlements where they practiced celibacy and were known for their industry, ingenuity, and craftsmanship. By 1960, the sect had largely died out.
{End of previous line is here, no Chr(13)}
According to this paragraph, _____.

What the heck? Did it always work like this? and how do I get my chr(13)'s back?

Thanks

Dorris
"You don't manage people. You manage things - people you lead" Adm. Grace Hopper
Pflugerville, between a Rock and a Weird Place
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform