Ben, are you SATTACHING another R:Base db or some other system? If it is another system, you will need to make sure the DATE/TIME are compatible. Check the top of the loop file for some settings that you may be missing.
--- Ben Fogt <[EMAIL PROTECTED]> wrote: > 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 > > Albert Berry Management Consultant RR2 - 1252 Ponderosa Drive Sparwood BC, V0B 2G2 Canada (250) 425-5806 (250) 425-7259 (708) 575-3952 (fax) [EMAIL PROTECTED]
