Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Email upon a record being appened to table
Message
De
02/08/2005 02:30:13
 
 
À
01/08/2005 14:26:00
Andy Roth
Neyenesch Printers
Californie, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01035803
Message ID:
01037722
Vues:
16
I just looked at it and it appears to be

>I was under the impression that the code at
>http://www.sweetpotatosoftware.com/SPSBlog/ for CDOSYS
>was all self contained and all that was required to send email.
>Is that not true?
>
>
>Andy
>
>
>>>Have you ever used CDOSYS ?
>>>I am running into a problem when it gets to .send()
>>>Error 1429
>>>The server response was not available.
>>>
>>>Any thoughts?
>>>
>>>
>>>Andy
>>>
>>>>>In V6 is there a way to set up a trigger to send an email out
>>>>>when a record is added to a table with the data that is
>>>>>in that record?
>>>>>
>>>>>If not any suggestions how to handle that?
>>>>>
>>>>>thanks
>>>>>Andy
>>>>
>>>>Andy,
>>>>Check Graig's BLOG, how to send an eMail from VFP.
>>>>http://www.sweetpotatosoftware.com/SPSBlog/
>>
>>Andy,
>>
>>Whatever method to send mail you use, you must be prepared for it to fail
>>
>>I think a trigger should never fail because a mail cannot be sent
>>
>>One way to implement is as follows
>>
>>Make a class MailQueue and instantiate it at the beginning of your application or when needed (max one instance running)
>>
>>A trigger may queue a mail, ie pass the data to the queue by calling a method, and return fast. Under no circumstance may it fail, ie if the object does not exist or the queue command fails, the trigger must still return TRUE
>>
>>The MailQueue has a timer that is fired every so often (eg 60 seconds or more).
>>When it fires it tries to send a mail from the Queue. If a send of a single mail fails, you retry (in the next timer cycle) up to max say 3 times. After that, discard the mail from the queue
>>
>>If the sending of a mail is successful, continue sending until the queue is empty
>>
>>When the MailQueue object destroys, it tries to send all the mail (once) that remains in the queue, and then destroys.
>>
>>
>>
>>The MailQueue runs in its own datasession. Thus it can keep a table of the mails, and temp files (attachments)
Gregory
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform