I just don't get it. I have a process that loops through a table that is sattached using Oterro 3.1. That process works fine, most of the time. To troubleshoot the problems that we're having, I am trying to do a couple simple counts on records in that same table. Every time I do a count (essentially of the records in the loop) the count is 0. If I browse the table, I don't see all of the records. It's missing about 10,000 records. That's a problem.
Yet, most times, the looping process runs reliably against that same table. Oh, the loop isn't my code, but I am using the same Sattached table within that same program. Essentially, select count(*) from DB_SAttached where MerID = .vMerid and ECKProcDate = .#date Where DB_SAttached is the table that the cursor is using in the loop. Any ideas? Is there some sort of Oterro Ritual I must do to cleanse my code? I just don't get it. I just want to know how many records processed. Is that so wrong? ;-) Ben Fogt
