Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Memo field on a report
Message
De
17/04/2001 15:04:11
 
 
À
17/04/2001 14:47:59
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00496285
Message ID:
00496299
Vues:
7
>Yet another basic question..... I would like to print the following in a report but would like to store the string in a memo field for easier editing. Placing it into a field on the report simply posts the text and doesn’t translate the functions. How should I best do this? Thanks!
>
>
>"I regret to inform you that your Sole Source of Heat permit " ;
>+ "expired on June 30th " + alltrim(str(year(date())))+".  " ;
>+ "Unless you come into our office at 301 W. Alder and renew " ;
>+ "your permit by " + DTOC(DATE() + 14) ;
>+ ", your permit cannot be renewed. Please take care of this " ;
>+ "matter as soon as possible."
>
There may be a better of doing this but I think you are going to have to use STRTRAN(). You can place a tag name like ~year and use STRTRAN() to search for it and replace it with the year. The StrTran() can be nested.

?STRTRAN(m.memo,'" + alltrim(str(year(date())))+"',TRANSFORM(YEAR(DATE())))


?STRTRAN(STRTRAN(m.memo,'~year',TRANSFORM(YEAR(DATE()))),'~date14',TRANSFORM(DATE()+14))


Hope this helps.
Fred Lauckner

You know, it works on my computer. I don't know what your problem is.

.Net aint so bad.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform