Jump to content

Script Crashes when no records exist

This topic is 6674 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am a psychiatrist and have written a file to manage my office. I have nearly brought my office management project to the point where I can use and depend on it except that a couple decisions I have made resulted in a problem I have not been able to solve. In short I have split the transactions into current transactions and previous (prior months) in order to make picking up the prior balance easier. However, this has complicated a script which runs through all the patients (a loop) and prints only those statements for patients with a positive balance. The script does strange things when it does not find a record in the current transactions table, specifically it winds up at the very last record (about #100) even though there are some in between that have positive balances and some between that have 0 balance but have transaction records, and I have been unable to write anything that successfully gets around this. I have tried using the Get (found set) calculation to go to the next record or to loop back (and essentially do the same thing) without success. My efforts at fixing the problem either result in no apparent change or in a endless loop which can only be ended by an escape command or dumps me out to one of the layouts exiting the script but does not go to the next record where there is in fact a record. Any advice?

Link to comment
Share on other sites

This topic is 6674 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.