Hi

I'm trying to find a range of records in an inline Action. The range is in a text field called field_name and I'm trying to find records that start with P, but which come before Pomology in the alphabet. I'm starting from a generic InlineAction which finds all P records. What I have is:

[FMP-InlineAction: -db=fos.fp5, -lay=fieldcodenametable, -sortfield=field_name, field_name===P*, -find]

How do I specify a range of values in an InlineAction?

I know this should be simple, but I can't seem to find the answer in any of my reference materials, at filemaker.com or here.

Any help would be much appreciated

Thanks

NZMatt

Try this:

FMP-InlineAction: -db=fos.fp5, -lay=fieldcodenametable, -sortfield=field_name, -op=gte, field_name=P, -op=lt, field_name=Po, -find]

Good Luck.

Garry

Hi Garry

Thanks for the suggestion. It brings to point another issue though. For some reason, the -op parameter doesn't seem to want to work. The above format actually ends up returning all results from the start of the list (alphabetically) up to the default maximum.

Is there something about the -op parameter that I don't understand? Do the gte, gt, lte, lt options only work with number fields?

Thanks

Matt

Hi

I just cottoned onto a solution. If you use the same request in each one (for all records with field name starting with P) and then control which records show using an FMP-If statement:

[FMP-InlineAction: -db=fos.fp5, -lay=fieldcodenametable, -sortfield=field_name, field_name===P*, -find]

[FMP-Record]

[FMP-If: field_name .lte. Pomology][FMP-Field: field_name]<br>[/FMP-If]

[/FMP-Record]

[/FMP-InlineAction]

Pomology<br>

[FMP-InlineAction: -db=fos.fp5, -lay=fieldcodenametable, -sortfield=field_name, field_name===P*, -find]

[FMP-Record]

[FMP-If: field_name .gt. Pomology][FMP-Field: field_name]<br>[/FMP-If]

[/FMP-Record]

[/FMP-InlineAction]<br>

Seems to work

NZMatt, try this:

[FMP-InlineAction: -db=fos.fp5, -lay=fieldcodenametable, -sortfield=field_name, field_name=P, field_name=>=, field_name=Po, -find][FMP-Record][FMP-Field: field_name]<br>[/FMP-Record][/FMP-InlineAction]