AfterInsertRecord trouble

[christappan]

I'm quick to admit that the problem may be me, but I'm trying to send an email as an AfterInsertRecord Event on a Grid Component with no luck. I've been successful using the same code (and even more complex) as an AfterUpdateRecord Event that works with no problem. I'm using a grid detail view to enter new records (as I am to update records), but while I don't get an error message of any kind when I enter a new record, the email also doesn't get sent.

I'm running against SQL Server Express tables--just letting you know in case this has something to do with it... Any help is much appreciated.

function AfterInsertRecord as v (e as p)
DIM pm as P
DIM ps as P
pm.from = "[email protected]"
pm.from_alias = "CNS WEB"
pm.to = "[email protected]"
pm.cc = ""
pm.bcc = ""
pm.subject = "Testing"
pm.message = "Test 1"
pm.html_message = ""
pm.attachments = <<%str%
C:\dev\test.zip
C:\my documents\report.zip
%str%
'optional header fields
pm.xmailer = "Alpha Mailer"
pm.lRelated = .F.
' send message
IF email_smtp_open(ps, "smtp1.deltacom.net")
email_smtp_send(pm, ps)
END IF
Email_smtp_close(ps)	
end function

[EricN]

Re: AfterInsertRecord trouble

Hi Chris,
I thought I saw the solution but as I was writing it, realized it was not. Perhaps you could try the email_send2(xx) method. This is what I use in many pages.

[Steve Wood]

Re: AfterInsertRecord trouble

I don't see any problem with your code so I would try the script in a bare A5W page to see if it works there. Side note - maybe its just me but I have always been shy to include anything very complex in a grid event, especially one that has to execute a labor intensive event, like sending an email. The browser has to wait for that event to complete and, if it hangs, so does the browser.

I've normally used the event to toggle a value in a table, or send out instructions as a 'request' to another process using Watch Directory that will see the instruction and execute it 'off line'. I have more faith that the event will take place and can insert control code to deal with it if if fails.

[christappan]

Re: AfterInsertRecord trouble

My understanding is that the email_send() and email_send2() functions don't work when you're developing a strictly web-based app and that you have to use the email_smtp_open(), email_smtp_send(), and email_smtp_close functions instead. Thanks anyway, though.

[Steve Wood]

Re: AfterInsertRecord trouble

I use email_send2() almost exclusively on web apps.

[christappan]

Re: AfterInsertRecord trouble

Thanks Steve and Eric. And I had apparently misunderstood on the difference on email_send2() and the email_smtp_...() functions.

There was some code error somewhere else that was keeping this code out for some reason--it's working properly now.

And Steve, I'm positive there are better ways to do some of the things I'm doing, but I'm still quite new to all of this. That said, those "more complex" things I eluded to were not all that complex if you're at all experienced with this stuff. Thanks again.

[Steve Wood]

Re: AfterInsertRecord trouble

not all that complex if you're at all experienced with this stuff

I was always a better programmer when there were FEWER options in the bag. One big probs I see with V10 is the opportunity for all of us to be all over the map on how we do the same things.