No records found

[Tmonk]

I have a script that is returning "no records found" even when it finds records. When I remove the steps with my message box it runs fine but doesn't tell the user if no records were found. I've attached it as a pdf. Can someone explain what step(s) are incorrect.

CoachInfo.PDF

[BobWeaver]

Change

If [status(CurrentFoundCount)>1]

to

If [status(CurrentFoundCount)>0]

[-Queue-]

Or just If [status(CurrentFoundCount)]

[Ugo DI LUCA]

Well, I'm kinda surprised....

Is english different from other languages that you'd accept an "s" at the end of "record" and use "are" while there is 0 record found :?

[-Queue-]

Yeah, you know we're weird like that. We don't use double negatives neither! (Well, those of us who know better do not...most of the time anyway.)

There is/was no record found to match your search.

There are/were no records found to match your search.

Both would be correct. It just depends whether the predicate nominative is chosen to be singular or plural. However, the plural form 'sounds' more natural, to me at least.

Zero referring to 'none' or 'no', however, would be plural. One is the only numerical adjective taken as singular. That's why it's the loneliest number.

[Ugo DI LUCA]

Thanks JT, great Math analysis of grammar