Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.filemaker > #1720

Re: Search Portal etc

Show all headers | View raw

John G schreef op 12-2-2014 01:00:
> E. Appeldoorn formulated the question :
>> JayBee schreef op 11-2-2014 15:24:
>>

>>> 'AM SLIM' returns nothing etc.
>>>
>>> I hope somebody can help
>>>
>>> Thanks
>>> J
>
> Whatever is a PM? :-Z
> One of the benefits of newsgroups is that lots of us learn things for
> latter without haveing to ask the qestion. :-?
>

John, a PM is a private mail. JayBee and I discussed this privately way 
before. She just wasn't sure about were to reach me now and tried my 
mailaddress and the newsgroup. But if you are interested: this is what I 
answered.

Hi Jenny, I can't exactly tell what you might have done.
Trying to recreate what youve done. But it seems you might have mistyped.

cFields are calculated field, returning text in this case)

Table ( Main)
Fields
cProductname ( "some¶product¶name¶and¶number")
gSearch = global textfield to hold the searchpattern
cFA = Case ( not IsEmpty ( gSearch ) ; gSearch ; 
"a¶b¶c¶d¶e¶f¶g¶h¶i¶j¶k¶lm¶n¶o¶p¶q¶r¶s¶t¶u¶v¶w¶x¶y¶z" )
cFZ= gSearch & "zzzzzzzzzzzzzz"

Create A T.O. of MAIN and call it searchMain
create a relation between cFA and cProductname. set the option to <= 
(cFA <= cProductname)
in the same window now add
cFZ >= cProductname

That should do it. If in doubt try it on an empty (new) file first, that 
makes is so much simpler to debug.

I might add that with newer FMP versions there are more flexible options 
now. If you have script triggers then you will also have Filtered 
Portalrecords. Both can be combined very fluently (but that is a 
personal opinion)
The cFA cFZ version does still work, but I have fazed it out for new 
solutions almost completely.

Did this solve the problem?

-- 
met vriendelijke groeten,
Erik Appeldoorn

Back to comp.databases.filemaker | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Search Portal etc JayBee <Jennifer_Beecroft@hotmail.com> - 2014-02-11 06:24 -0800
  Re: Search Portal etc "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2014-02-11 22:21 +0100
    Re: Search Portal etc John G <greentest@ozemail.com.au> - 2014-02-12 11:00 +1100
      Re: Search Portal etc "E. Appeldoorn" <ursus.kirk@ziggo.nl> - 2014-02-12 09:25 +0100
        Re: Search Portal etc Martin Τrautmann <t-usenet@gmx.net> - 2014-02-12 09:32 +0000
          Re: Search Portal etc Martin Τrautmann <t-usenet@gmx.net> - 2014-02-12 09:34 +0000
  Re: Search Portal etc Thibaud Taudin Chabot <tchabot@hccnet.nl> - 2014-02-12 10:24 +0100

csiph-web