SQL Execution error email
Last Post 04-12-2007 08:41 AM by Chad Nash. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Paul JenrowUser is Offline
skipping stones
skipping stones
Posts:17
Avatar

--
04-11-2007 10:28 PM
    I attempted to run a form completion SQL event and triggered an error. It was great to see that the form module generated an email indicating that a SQL execution error had taken place.
    Is there anywhere to see the error detail?
    This was the SQL string I attempted to execute:
    EXECUTE prInsertReg $(symp), $(tsymp), $(dact), $(whyasct)
    I ran this successfully within Management Studio, but it didn't seem to work as entered in the module. I would think seeing the error details might shed some light.
    Thanks again for such a great module!
    Chad NashUser is Offline
    Posts:5260
    Avatar

    --
    04-12-2007 08:41 AM

    Hi. Yes something like this needs to be added in a figure release. My guess based on your suggestion is that you need '' marks around the tokens.

    I.e.
    EXECUTE prInsertReg '$(symp)', '$(tsymp)', '$(dact)', '$(whyasct)'



    ---
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi