One of the three major laws of WHEN-CREATE-RECORD

Source: Internet
Author: User
The three major laws of WHEN-CREATE-RECORD are inferred as follows:

1. If the BLOCK is INSERT-able and the number of records in the BLOCK is 0, it will be called before PRE-BLOCK
2. If the BLOCK is the current BLOCK and can be inserted, it will be called if the number of records is 0. For example, in CLEAR_BLOCK mode, when a query is executed but no record is found
3. If the BLOCK status is NEW, it will be triggered every time you focus on the BLOCK; QUERY, CHANGED will not

A major inference of WHEN-CREATE-RECORD

1. premise: the relationship between the master and slave blocks. The DEFFER of the relationship is FALSE. The slave block can be inserted.

WHEN the primary block RECORD is moved from one RECORD to another, if the slave block RECORD is not 0, the WHEN-CREATE-RECORD is triggered three times. If the value is 0, the WHEN-CREATE-RECORD is triggered four times.
Proof:

First, GO_BLOCK goes to the slave block and CLEAR_BLOCK. The second law is used to trigger a request;
GO_BLOCK to the primary block, NEXT_RECORD;
From GO_BLOCK to slave block, trigger once using the first law;
Execute the query: First CLEAR_BLOCK, trigger once using the second law; execute the query; if the query result is 0, use the second law to trigger once;

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.