My Lapinator payment email loading program is moving nicely along, but yesterday I had to overcome a really strange problem.
The emails are downloaded from Yahoo in a .EML format and I load the file names into a normal R:Base table. Then I set up a declare cursor to load each separate email file into another regular table. When the program hit the Load command within the cursor it would kick me completely out of R:Base. (6.5++ last build Under XP Pro with 1 gig of memory with a standard SetCon.cmd file that takes care of settings.)
When I ran the Load command at the R> to grab the three separate email files there was no problem.
Talked with Dennis McGrath and ditched the cursor and just used a While Loop. Same Problem. Got rid of the while loop and just used a GoTo. Now I could run the program 2 - 4 times in a row, but the next time it would kick me out of R:Base.
Talked with Dennis again and re-connected the database before each Load command in the GoTo loop. Now it works fine.
The reality is that I will probably only load and process one email file at a time (easier to process and parse). Thus, I have a good solution to this problem, but still wonder why it happened?
Jeff Ward www.lapinator.com
--- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [EMAIL PROTECTED]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [EMAIL PROTECTED]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================
