Search the Community
Showing results for tags 'trigger actions'.
I'm trying to create a trigger that will add fields to a bunch of related tables based on the new CCTAproject_id that is entered on the parent table. It won't let me get rid of the ID field for some reason so I'm guessing that is a necessary field. My solution was to take the max existing value in the ID field and add a 1, so that new records increase sequentially by 1. I get an error when using this method, "Column '#inserted.CCTAproject_id' is invalid in the select list because it is not contained in either an aggregate function of the GROUP BY clause, (error code: SQL8120). But if I r
Hello, I am new to Caspio, I encounter a problem here. I have two Tables Table#1: Investment(Investment_ID, Client_ID, Latest Transaction date, BookValue, MarketValue) e.g. Invest001|Nov 1, 2018|500|1000 Invest001|July 1, 2018|800|2000 Table#2: Investment Transaction(Investment_ID, BookValue, MarketValue, Transaction_Date) e.g in Table #1 I have following records, Invest001|100|100|Oct 1, 2018 Invest002|800|2000|July 1, 2018 Invest001|100|200|Oct 10, 2018 Invest001|100|300|Oct 15, 2018 Invest001|200|500| Sep 1, 2018