Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

[WindForce]

Hi
I have a dialog used for adding/editing records in a grid. The DB is mySql.
In that dialog, i have the following code in my afterDialogValidate

function afterDialogValidate as v (e as p)

ExecuteServerSideAction("Save Data::SaveDialog")

dim myargs as sql::Arguments
myargs.add("whatOrderID", e.dataSubmitted.OrderID )
dim FileName as C
FileName = "C:\MyCustomer\Reports\Res"
FileNAme = FileName + alltrim(str(e.dataSubmitted.OrderID))+".pdf"
dim options as p
options.filter = "OrderID = :whatOrderID"
report.SaveAs("Daily Confirmation", "PDF", "", "", FileName, .f., options, myargs)
'debug(1)
dim curEmail as C = e.dataSubmitted.CustomerEMail
dim curSubject as C
dim curMessage as C

curSubject = "Reservation "+alltrim(str(e.DataSubmitted.OrderID))
curMessage = "Dear "+e.dataSubmitted.Contact + Crlf()
curMessage = curMessage + "Please find attached the details of your Reservation"+crlf(2)

dim pm as P
dim ps as P
if (email_smtp_open(ps, myserver, 25, myUser, myPassword)) then
    pm.to = curEMail
    pm.from = "someemailaddress"
    pm.subject = curSubject
    pm.message = curMessage
    pm.attachments = FileName
    email_smtp_send(pm, ps)
end if
email_smtp_close(ps)

In working preview, the code works great. Record is saved in the DB, PDF report gets generated in due place, and the generated report is emailed.
When running in the browser, after publishing the project, clicking on submit does not seem to do anything ( i.e dialog stays put, and stays dirty ) but noticed the record is saved in the DB. The rest of the code does not run, and the dialog doesn't close ( which is obvious if the code didn't run )

Any clues?
Thanks,
Jaime

[Jay Talbott]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

One thing you can do to debug the script when it is running in the browser is to add code to the afterDialogValidate script to write to text files.
Put the command in three or four places throughout the script, and write variable values to each files. Then look at the files after you run the script to see how far the script got.
Hope this helps.
Jay

[WindForce]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

Thanks Jay.
Of course that's what i did before posting.
After some more testing, the problem is *nothing* runs after the "Save Dialog" action, which if you come to think of it, is logical - in the action itself, i selected "Edit the record just entered" in the properties since it's the closest to what i want, but in fact what i would want to see there is "continue execution" or something like that...
What puzzles me is how come this code works in working preview ( all the code in the afterdialogvalidate runs even what's after the "Save" ) then closes the dialog and, as expected, brings me back to the calling grid, while in the browser code just stops after the "Save" action...

Jaime

[Jay Talbott]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

Then would it work to move this line:
ExecuteServerSideAction("Save Data::SaveDialog")

down to the bottom of the script?
Jay

[WindForce]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

Thanks Jay.
Finally found the problem, which i don't know how to solve. The problem is that the line

report.SaveAs("Daily Confirmation", "PDF", "", "", FileName, .f., options, myargs)

does not run in the browser, and stops execution right there, so i guess this command is not supported other than in the desktop? In that case, i really don't know how to just email a pdf report upon saving...

[Jay Talbott]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

This quote:

Hi Dave,

I recently had issues with this command.

After I got it figured out, I posted my resolution.

Hope this helps.

Gregg

:Report.SaveAs("reportname","PDF","","","c:\reports\filename.pdf",.F.) works great for desktop apps, but fails when being called from a .a5w page.
:Report.SaveAs("reportname@c:\datadir\tablename.ddd","PDF","","","c:\report\filename.pdf",.F.) works great for desktop apps and when being call from a .a5w page.

is from this thread:
http://msgboard.alphasoftware.com/al...ead.php?103073

Hope this helps.
Jay

[WindForce]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

Thanks! In fact i saw that thread and forgot about it.
Still, i am using mySQL, and as per Steve Wood's advice, i tried

Report.SaveAs("report name@c:\A5WebRoot\MyCustomer\project...t\filename.pdf",.F.)

with no success...

[WindForce]

Re: Code after "Save Dialog" not running in AfterDialogValidate - only in browser...

Ok, got it finally running using A5W_Report_SaveAs .
Still , this doesn't work as expected in the browser. First a small recapitulation of the relevant code:

ExecuteServerSideAction("Save Data::SaveDialog")
dim myargs as sql::Arguments
myargs.add("whatOrderID", e.dataSubmitted.OrderID )
dim FileName as C

When running in the browser, e.dataSubmitted.OrderID is empty ( in working preview the newly generated OrderID is in there ) so the rest of the code runs with an empty value for OrderID...Why is that?