JR Fent
|
| Posted: 01/30/2006, 10:02 AM |
|
I'd like to pull down data from sql and not update - I just want it to email the results to someone that needs to see them.
Is there a way to create a record build that would do this:
1) Query te SQL
2) Display the result
3) allow modificationes (such as adding a note and an email address to forward to.
4) create and send as an email
5) NOT CHANGING THE ORIGINAL RECORD.
Thnks for any ideas.
JR
|
|
|
|
Benjamin Krajmalnik
|
| Posted: 02/07/2006, 4:47 PM |
|
Sure.
Use a custom update of type SQL. I do this all the time where I am calling
my won stored procedure wrappers where I need to retrieve parameters and
perform error checking, which CodeCharge's built-in SP support does not
have.
What I do is have a custom "Update" statement such as:
"Select Top 1 * from SomeTable".
In either the before update, after update, or validate, you can latch your
own code to do what you want.
|
|
|
|
|
|
