[ https://issues.jboss.org/browse/TEIIDDES-1270?page=com.atlassian.jira.plu... ] Van Halbert commented on TEIIDDES-1270: --------------------------------------- Since the majority of the values being passed in will come from NEW or OLD, shouldn't these prefixes for values be used in the templates? -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIIDDES-1270?page=com.atlassian.jira.plu... ] Mark Drilling commented on TEIIDDES-1270: ----------------------------------------- Ramesh, can you provide template examples that I can use in the designer wizard? I've also asked Chuck for his input. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIIDDES-1270?page=com.atlassian.jira.plu... ] Mark Drilling edited comment on TEIIDDES-1270 at 3/19/12 12:05 PM: ------------------------------------------------------------------- I think I can just change the current templates as follows - correct? ======================== "WAS" ======================== INSERT: CREATE VIRTUAL PROCEDURE BEGIN INSERT INTO [TABLEA] ([COL1], [COL2], [COL3]) VALUES ([val1], [val2], [val3]); END UPDATE: CREATE VIRTUAL PROCEDURE BEGIN UPDATE [TABLEA] SET [COL1]=[val1], [COL2]=[val2], [COL3]=[val3] WHERE ([PK-KEY-COL])=[value]; END DELETE: CREATE VIRTUAL PROCEDURE BEGIN DELETE FROM [TABLEA] WHERE ([PK-KEY COL]) = [value]; END ======================== "NOW" ======================== INSERT: FOR EACH ROW BEGIN ATOMIC INSERT INTO [TABLEA] ([COL1], [COL2], [COL3]) VALUES ( NEW.[COL1], NEW.[COL2], NEW.[COL3] ); END UPDATE: FOR EACH ROW BEGIN UPDATE [TABLEA] SET [COL1]= NEW.[COL1], [COL2]=NEW.[COL2], [COL3]=NEW.[COL3] WHERE [PK-KEY-COL]=OLD.[PK-KEY-COL]; END DELETE: FOR EACH ROW BEGIN DELETE FROM [TABLEA] WHERE [PK-KEY COL] = OLD.[PK-KEY-COL]; END was (Author: mdrillin): I think I can just change the current templates as follows - correct? ======================== "WAS" ======================== INSERT: CREATE VIRTUAL PROCEDURE BEGIN INSERT INTO [TABLEA] ([COL1], [COL2], [COL3]) VALUES ([val1], [val2], [val3]); END UPDATE: CREATE VIRTUAL PROCEDURE BEGIN UPDATE [TABLEA] SET [COL1]=[val1], [COL2]=[val2], [COL3]=[val3] WHERE ([PK-KEY-COL])=[value]; END DELETE: CREATE VIRTUAL PROCEDURE BEGIN DELETE FROM [TABLEA] WHERE ([PK-KEY COL]) = [value]; END ======================== "NOW" ======================== INSERT: FOR EACH ROW BEGIN ATOMIC INSERT INTO [TABLEA] ([COL1], [COL2], [COL3]) VALUES ([val1], [val2], [val3]); END UPDATE: FOR EACH ROW BEGIN UPDATE [TABLEA] SET [COL1]=[val1], [COL2]=[val2], [COL3]=[val3] WHERE ([PK-KEY-COL])=[value]; END DELETE: FOR EACH ROW BEGIN DELETE FROM [TABLEA] WHERE ([PK-KEY COL]) = [value]; END -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira

[ https://issues.jboss.org/browse/TEIIDDES-1270?page=com.atlassian.jira.plu... ] Ramesh Reddy commented on TEIIDDES-1270: ---------------------------------------- That looks good. Note, my comment from above about complex queries with multiple tables, you want see if you can handle that situation too. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira