Using Fields within Memo Text and use in Report ?

Is it possible in Foxpro 2.6 for Dos, to use Fields within Memo Text, and
then print that Memo in Report, which should replace the field names with
their values.

Something like TextMerge option in foxpro.


For example:

I put following in Memo Field.

My Name is <<<cName>>>


When I print this field in report, it should display following.

My Name is Luqman
My Name is Usman
My Name is Aman

Is it possible ?

Best Regards,

Luqman

Anders
Fri Jun 24 05:45:36 CDT 2005

Suppose you have your memo text in a table T1 and you data in a table T2

SELECT T2.*, TEXTMERGE(T1.memotext) myText FROM T2 INTO CURSOR xx

You would need to open T1 before running the query.
Do not put any table references in the memo, that is use <<lastname>>, not
<<T2.lastname>>.
Then use xx as the report's data source.
Tested in VFP9 so I'm not sure how it would work in 2.6 DOS

-Anders



Den 05-06-24 09.52, i artikeln #mtL5IJeFHA.3032@TK2MSFTNGP10.phx.gbl, skrev
"Luqman" <pearlsoft@cyber.net.pk>:

> Is it possible in Foxpro 2.6 for Dos, to use Fields within Memo Text, and
> then print that Memo in Report, which should replace the field names with
> their values.
>
> Something like TextMerge option in foxpro.
>
>
> For example:
>
> I put following in Memo Field.
>
> My Name is <<<cName>>>
>
>
> When I print this field in report, it should display following.
>
> My Name is Luqman
> My Name is Usman
> My Name is Aman
>
> Is it possible ?
>
> Best Regards,
>
> Luqman
>
>

Andrew
Fri Jun 24 06:57:47 CDT 2005

"Anders" <anders.altberg@telia.com> wrote in message
news:BEE1B0F0.135E%anders.altberg@telia.com...
> Suppose you have your memo text in a table T1 and you data in a table T2
>
> SELECT T2.*, TEXTMERGE(T1.memotext) myText FROM T2 INTO CURSOR xx
>
> You would need to open T1 before running the query.
> Do not put any table references in the memo, that is use <<lastname>>, not
> <<T2.lastname>>.
> Then use xx as the report's data source.
> Tested in VFP9 so I'm not sure how it would work in 2.6 DOS

I think it will be messy because you can only SET TEXTMERGE TO in 2.6,
there's no TEXTMERGE() function.

It does say, however, that if you textmerge a memo field which contains
textmerge delimiters with field names etc. inside then they also are
evaluated.


Personally I think I'd roll my own.

--
Regards
Andrew Howell

Luqman
Fri Jun 24 07:01:03 CDT 2005

Hi Anders,

Unfortunately TEXTMERGE Function does not exist in Foxpro for Dos, well I
tried this in Visual Foxpro 7.0, and it says, "String too long to fit", as
select query is putting memo data in a Character Field, any idea, how can I
put the memo field into Cursor Memo Field, using VFP 7.0.

Best Regards,

Luqman




"Anders" <anders.altberg@telia.com> wrote in message
news:BEE1B0F0.135E%anders.altberg@telia.com...
> Suppose you have your memo text in a table T1 and you data in a table T2
>
> SELECT T2.*, TEXTMERGE(T1.memotext) myText FROM T2 INTO CURSOR xx
>
> You would need to open T1 before running the query.
> Do not put any table references in the memo, that is use <<lastname>>, not
> <<T2.lastname>>.
> Then use xx as the report's data source.
> Tested in VFP9 so I'm not sure how it would work in 2.6 DOS
>
> -Anders
>
>
>
> Den 05-06-24 09.52, i artikeln #mtL5IJeFHA.3032@TK2MSFTNGP10.phx.gbl,
skrev
> "Luqman" <pearlsoft@cyber.net.pk>:
>
> > Is it possible in Foxpro 2.6 for Dos, to use Fields within Memo Text,
and
> > then print that Memo in Report, which should replace the field names
with
> > their values.
> >
> > Something like TextMerge option in foxpro.
> >
> >
> > For example:
> >
> > I put following in Memo Field.
> >
> > My Name is <<<cName>>>
> >
> >
> > When I print this field in report, it should display following.
> >
> > My Name is Luqman
> > My Name is Usman
> > My Name is Aman
> >
> > Is it possible ?
> >
> > Best Regards,
> >
> > Luqman
> >
> >
>