View Single Post
  #1  
Old 02-15-2007, 04:32 AM
conred conred is offline
Junior Member
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
conred is on a distinguished road
Default INSERT Trigger issue.

Hello all of you,
I would like to use WHERE clause in constructing larger statements stored inside a database table as a string. Inside the INSERT Trigger for a different table, I would like to be able to:

<get the tuple with the WHERE clause I want to use>;
SELECT * FROM t WHERE <use code in database>;

Can I pull out this data and append the data to the second statement and execute it?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
  Webmaster Forums - View Single Post - INSERT Trigger issue.
View Single Post
  #1  
Old 02-15-2007, 04:32 AM
conred conred is offline
Junior Member
 
Join Date: Nov 2006
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
conred is on a distinguished road
Default INSERT Trigger issue.

Hello all of you,
I would like to use WHERE clause in constructing larger statements stored inside a database table as a string. Inside the INSERT Trigger for a different table, I would like to be able to:

<get the tuple with the WHERE clause I want to use>;
SELECT * FROM t WHERE <use code in database>;

Can I pull out this data and append the data to the second statement and execute it?
Thanks. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote