Jump to content

Search the Community

Showing results for tags 'trigger actions'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Caspio Bridge
    • General Questions
    • Caspio JavaScript Solutions
    • Tables, Views and Relationships
    • Import/Export and DataHub
    • DataPages
    • Deployment
    • Security, Authentications, Roles, SAML
    • Styles and Localizations
    • Parameters
    • API and Integration
    • Calculations and aggregations
    • User JavaScript and CSS Discussions

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


MSN


Website URL


ICQ


Yahoo


Skype


Location


Interests

Found 2 results

  1. 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 remove the number block containing the "MAX etc" and just leave it to equal a static number, the trigger works. I don't understand what the error means by grouping since the ID field is an integer and I'm not trying to group different field. Is there a way to manipulate the trigger so the numbers can increased based on existing values?
  2. 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 Invest001|500|1000|Nov 1, 2018 Here I would like to make the following action execute whenever I update the table. Latest Transaction Date = Table#2:Latest Investment Transaction:Transaction_Date BookValue = Table#2:Latest Investment Transaction: BookValue MarketValue = Table#2:Latest Investment Transaction: MarketValue What can I do to make this happen? Any help will be appreciated, Thank you very much in advance,
×
×
  • Create New...