FAQ part 4: Troi
Text Plug-in questions
Table
of Contents
| Part
1
| Part
2
| Part
3 File Plug-in
| Part 4 Text Plug-in | Part
5 URL Plug-in
Back to top
Text Plug-in Questions
FileMaker Pro 8 and SumText
This section below regards FileMaker Pro 8 and the
SumText functions.
Updated January, 9th, 2006: The release of FileMaker
Pro 8.0v2 (and later) fixes the problem with the SumText function. This
means that now the old syntax works again!
Q. Which syntax for SumText is
recommended? 
With the the release of the update of FileMaker Pro 8.0v2
the original syntax of the SumText calculation is now again
working properly. As the original syntax is more general we
strongly recommend to use this syntax.
The recommended original syntax
looks like this:
1) In your related file define a calculation field.
cSumTextCalc = TrText_SumTextCalc( TextField
)
2) In the main file define a field for the SumText
result:
SumTextResult = Left( TrText_SumTextStart(
"¶") & Sum(RelationName::cSumTextCalc) ; 0 )
& TrText_SumTextResult( "" )
For a more extensive discussion see also the example
files and the user guide of Troi Text Plug-in.
Q. Why is the range for
sumTextInstanceIDs (of SumText on FMP8) limited to 1 to
20?
This is because of memory constraints.
If you update to FileMaker Pro 8.0v2 and use the original
syntax of the SumText calculation, this limitation is
not present.
Q. When do you need to have an unique
SumTextID (in SumText on FMP8)?
The sumTextInstanceIDs need to be unique to help the plug-in
identify what FileMaker is trying to sum. The
sumTextInstanceIDs needs to be different if during this run
of FileMaker (essentially the life of the plug-in's memory)
the sum may be calculated.
If you update to FileMaker Pro 8.0v2 and use the original
syntax of the SumText calculation, you don't need a
sumTextInstanceID.
Q. Do I need to use the new SumText
syntax in scripts?
As far as we can tell the old syntax will work fine IN
SCRIPTS.
If you update to FileMaker Pro 8.0v2 and use the original
syntax of the SumText calculation will work fine in both
calculation and scripts!
Q. Are the new style definitions
needed only in mixed 7/8 environments? If I'm requiring FM8,
will the old syntax still work?
The old syntax does work in scripts, but not on layouts as
FileMaker Pro 8.0v1 is caching the result.
If you update to FileMaker Pro 8.0v2 and use the original
syntax of the SumText calculation will work fine on a
layout too.
Q. Can it be that SumText is not
reliable in FileMaker Pro 8.0v1, and sometime gives the
wrong results?
Yes, there is a problem with FileMaker Pro version 8.0v1
sometimes caching the wrong results. This bug is fixed in
FileMaker Pro version 8.0v2. Please update to the latest
version of FileMaker Pro.
NOTE the original and more universal
original syntax to implement
SumText now also works properly.
Back to top
Other Questions?
If your question is not answered here, please look in the
documentation that comes with the plug-in. We will be adding
more to this FAQ. If you have suggestions please
.
|
