Pattern Count on a field in a different database

[tallboy755]

Is there a way to run a pattern count on a field from a related file ... here is what i am trying - PatternCount(DEV_Cadyware::Info_Package,"J") - and its not working

any ideas would be appreciated

[LaRetta]

Hi Andrew,

Your example should work just fine. Make sure that the calculation is NUMBER.

Cheers,

LaRetta

[tallboy755]

it is a number ... its just driving me nuts .... anyone have ANY IDEA WHY THIS WON'T WORK?:

[-Queue-]

Just so you are aware, this will only search for "J" in the first related record (based on the relationship's sort order), in case you were trying to search throughout the related file.

[tallboy755]

Nope ... I am just trying to do a pattern count on one field of one record ...