Thanks Buddy! It looks like that did the trick. I feel a lot better about my code now.
Ben -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of Walker, Buddy Sent: Thursday, August 18, 2005 2:41 PM To: RBG7-L Mailing List Subject: [RBG7-L] - RE: Counting from an Oterro Attached table Ben I was having a problem with browsing a Sattached table, using Oterro 3.1. After sending all the info to RBTI it turned out that I needed to tell oterro where to write temporary files by modifing the oterro.cfg. SCRATCH C:\TEMP I think Razzak stated in one of his Tips of the day you can also use SCRATCH TMP Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Ben Fogt Sent: Thursday, August 18, 2005 12:38 PM To: RBG7-L Mailing List Subject: [RBG7-L] - Counting from an Oterro Attached table 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
