Why doesn't my script work in IWP?

[MariaAux]

HI,

I've got an English teaching Children's games database. One of the fields is 'Topic' (animals, clothing, foods etc.) I have another field called 'Flashcard Game' which basically covers all games that are played with flashcards - and thus any topic can be covered as long as you have animal, clothing food flashcards etc.) When the game is a flashcard game, the field is 'Yes'.

So I write the 'Perform Find script' that if 'Flashcard game' is checked as 'Yes', first search for the other criteria selected by clearing the 'Yes' and then extend the found set with all the 'Flashcard games'. The script works fine inside FMP but returns 'No Records found' in IWP most of the time, but occasionally returns the right found set.

I've attached a screenshot of the script.

Why would it work locally but not in IWP?

Why would it work occasionally in IWP but fail most of the time? Why the inconsistent results?

Is there a way to copy a script and paste it here without making a screenshot?

Schematically, have I set up my database logic poorly but doinf it this way?

Thanks so much for all your advice,

Have a great weekend,

Sincerely

Maria

[Fitch]

1. IWP doesn't maintain constant communication with the database. You have to tell it when it needs to do so. Try placing a "commit records/requests" step after the "clear."

2. Try printing your script to a PDF. (This is also a great way to search your scripts when troubleshooting.)

3. Schema-wise, that's not much information to go on. I wonder if "flashcard game" should be a "game type" field: "flashcard" would be one possible type.