josephstern

This is maddening. The only way I can get this to work is to enter Preview mode, then use the "Save as PDF" button, then open the PDF, and print that. I can't even print to PDF. This seems to be the only way. It's nuts.

Sorry for the inaccuracy. It's an FM Server 11.

Thanks - using an FMP 11 server on a Mac Mini. Right, but I was doing a double-check since another instance could grab a record between the find and this step. I'm sorry I wasn't clearer here. The "<send email>” was a long winded external call to my SMTPit plug-in. I'm definitely getting more than 100 emails here. I agree that the "Open" step, if completed without error, should do the trick, but somehow it's just not. Maybe I'm not correctly testing for the error? Should I be clearing the error register somehow before performing the "Open" step so that I'd be sure to get an accurate result? I like the logging idea and I'll give that a shot. But even if I can show that two instances are sending an email from the same record, then what? Thanks for all the replies and help!

I have a few FMP projects that I run where I need to process tens of thousands of records, and each process takes time. So I want to be able to set up additional instances that can just run overnight on various computers in my office to accomplish these projects. My problem is, one instance will grab a record, and then sometimes another instance will grab the same record and process it. While this doesn't really matter (except for the wasted time) for some applications, in particular, for marketing emails, this is a problem. I'm trying this: Set Error Capture [ On ] 
Perform Find [ Specified Find Requests: Find Records; Criteria: Test::Sent: “="no"” ] Go to Record/Request/Page [ First ] Loop 
 If [ Test::Sent = "No" ] Open Record/Request
 Set Field [ Test::Sent; "Yes" ] If [ Get ( LastError ) <> 301 ] Set Field [ Test::Result; “<send email>” ] End If Go to Record/Request/Page [ Next; Exit after last ] End If End Loop So, say I have 100 matching records. I'll get 110 or so emails. I can't figure out how to truly get each instance not to step on the toes of another instance. Any ideas? I've try committing records, flushing the cache to disk, etc.