Why can't FMP-IF compare to it's own internal variables?

[P. Stone]

Since I have apparently found a bug in CDML access where as if you do a
search and should be retrieving 0 records found, FMP server tells you you've
found THEM ALL! (WRONGO!)

So I tried to make a trap:

[FMP-IF: CurrentRecordCount .eq. CurrentFoundCount]
0 records found.
[FMP-ELSE:]
....regular code here
[/FMP-IF]


This would in effect compared total items in database to returned found
items and if you find all, then you can trap it...

UNFORTUNATELY FMP WON'T COMPARE INTERNAL VALUES TO INTERNAL VALUES???

This is hair pulling... Come on... this SHOULD work but it doesn't....Why??!
WHYY!!?? (<--- Said in a Poltergeist movie tone right after "You moved the
headstones but you left the bodies!")

Thanks - ps

[Thomas Berg]

It's been a while since I last did CDML, and I'm kind of fuzzy on the
details, although I do remember the hair-pulling.. But here's something
that might be worth a try.

Define an unsaved calculation field
CntFound = Status(CurrentFoundCount)
then use this field instead of the CurrentFoundCount CDML keyword. So your
if will become
[FMP-IF: CurrentRecordCount .eq. Field:CntFound]

I always feel a little queasy when I create a field like this. I feel that
the nature of this information (the found count) is so un-fieldlike. But I
do what I gotta.

Thomas

"P. Stone" <nospam@nospam.com> wrote in message
news:bnrnl8$2047$1@news.wplus.net...

> Since I have apparently found a bug in CDML access where as if you do a
> search and should be retrieving 0 records found, FMP server tells you

you've

> found THEM ALL! (WRONGO!)
>
> So I tried to make a trap:
>
> [FMP-IF: CurrentRecordCount .eq. CurrentFoundCount]
> 0 records found.
> [FMP-ELSE:]
> ....regular code here
> [/FMP-IF]
>
>
> This would in effect compared total items in database to returned found
> items and if you find all, then you can trap it...
>
> UNFORTUNATELY FMP WON'T COMPARE INTERNAL VALUES TO INTERNAL VALUES???
>
> This is hair pulling... Come on... this SHOULD work but it

doesn't....Why??!

> WHYY!!?? (<--- Said in a Poltergeist movie tone right after "You moved the
> headstones but you left the bodies!")
>
> Thanks - ps
>
>

[P. Stone]

"Thomas Berg" <tbSPAMISBADerg@insight-system.co.jp> wrote in message
news:bnsdo8$216$1@nn-tk102.ocn.ad.jp...

> It's been a while since I last did CDML, and I'm kind of fuzzy on the
> details, although I do remember the hair-pulling.. But here's something
> that might be worth a try.
>
> Define an unsaved calculation field
> CntFound = Status(CurrentFoundCount)

Hmm... this is in html... I'm still learning CDML so does it allow for
variable assignment?
I don't remember html acting like BASIC/C/Perl on it's own...

[Thomas Berg]

When I say "Define an unsaved calculation field", I mean load up FileMaker
and add a field to the file.
Of course "Status(CurrentFoundCount)" doesn't have any meaning in HTML.

> Hmm... this is in html... I'm still learning CDML so does it allow for
> variable assignment?
> I don't remember html acting like BASIC/C/Perl on it's own...
>

> > Define an unsaved calculation field
> > CntFound = Status(CurrentFoundCount)