troi logo-homeproductspurchasesupportnewsaboutliststipslinks-

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

Text Plug-in questions New!

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? New!
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?New!
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)?New!
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?New!
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?New!
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?New!
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 .


www.troi.com/support   © 2010 Troi Automatisering, all rights reserved.