Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Variable not storing all information for Body of Email
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8
OS:
Windows XP SP1
Network:
Windows 2000 Server
Database:
Visual FoxPro
Divers
Thread ID:
01120917
Message ID:
01120927
Vues:
12
>Sorry Borislav not explaining myself correctly. I am using the Outlook mail class from this site. When I run the sendmail procedure there is a variable called lcbodytext used to populate the body of the email.
>
>I want to populate this variable with some header information, the contents of a query from a cursor and some footer information. Dependant on the number of records in the query what I have noticed is that not all information is stored to the variable (Chopping off some records and the footer). Thats why I was just wandering if there is a limitation of the amount of characters you can store to a variable? I know I could create a txt file with the query results in and attach it but I would like to put everything in the body of the email.
>
>Neil

From Limitations (HELP):

Other Capacities
Maximum # of characters per character string or memory variable 16,777,184

You could do this just for testing:
After you build this string, export it to file with STRTOFILE() and open this file with notepad to see if all info is in it. If so the you should seach somewhere else to find who cut you string.

Becuase I never used this class I don't know what it do. Also I am not sure what is the maximium number of chars for eMail body when you send it directly from Outlook.

Another suggestion, when you export that variable to file, open that file, select all->Copy. Then try to Paste its contetns directly to Outlook and send this mail to you, just to see if Outlook will cut the body.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform