Using:
Windows 7 64bit
VB.net 2010
The latest devart.data.PostgreSQL (.net data connection)
PostgreSQL 9.0.2
Hi all,
Question: Is there a way to pass a variable from an application’s user interface to the database such that it would be visible inside a database trigger and any corresponding function call?
When a record gets deleted, a table trigger fires that writes to a log table. What I want to do is pass a variable from the user interface to the trigger function so I can write the variable’s value to the log record that I create in a function called from the trigger event. I’m not sure how this could even be accomplished unless somehow it was possible to pass a variable through the data connection itself. But even then, how would the trigger function be able to see it and pass it along? Is there some other mechanism or approach I should be taking?
I’m thinking it’s not possible but thought I would ask anyway.
Thanks for any comments,
Chris Campbell
ccampbell@CascadeDS.com