PROBLEM: When attempting to Post Participation in CMS Membership, you're receiveing the error message "An error was triggered in the nRecords method on an object of TCursor Type."
SOLUTION: From CMS for Windows, click File | Utilities | CMS Table Repair.
On the Table Repair Utility Screen, click Browse in the upper right corner. Find the table ENTERPAR.DB and click Open.
Jot down the Number of Records, located about half way down the left side of the screen. You'll need that number in a few seconds.
Click the Verify Button at the bottom of the screen. It will come back with either "Table and Header Verify Okay" or "Table Requires a Rebuild". Jot down this message and click OK.
Click the Rebuild Button at the bottom of the screen. When complete, it will come back with a Number of Records Successfully Recovered. That number should match the number you jotted down previously. Click OK | OK.
Repeat with the following tables:
- PRIV: ANSWER.DB
- PRIV: AVAIL1.DB
- PRIV: INSERTED.DB
- PRIV: SELECTD1.DB
With the last few PRIV: tables, at the bottom of the Browse button, you'll see Alias : WORK. Click the little down arrow next to WORK and choose PRIV.
Now find the table INSERTED.DB and click Open.
Click the Rebuild button at the bottom of the screen. Repeat with the remaining PRIV: tables.
Once complete, click OK | OK | Close.
Now go back into Membership and attempt to post the Participation again. It should run without errors!