Home >Backend Development >PHP Tutorial >ACCESS trigger delete table event variable usage and continuous deletion_PHP tutorial
ACCESS trigger delete table event variable usage and continuous deletion_PHP tutorial
- WBOYOriginal
- 2016-07-12 08:58:101139browse
ACCESS trigger delete table event variable usage and continuous deletion
After the TABLE DELETE event of ACCESS is triggered, an [old] record will appear. This record is very useful and can Used for conditional judgment.
In the table event as shown below, after deleting a record, you can use the [old] record connection to perform multiple operations to delete related records.
One thing to note is that the FOR loops of the two deletion actions need to be at the same level!
It should be noted that the variable OldFTid at '1' can be used at '2'. The syntax is:
When condition = [ReviewData].[FTid]=OldFTid
Reference:
https://msdn.microsoft.com/zh-cn/library/ff973807 .aspxStatement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Explanation on how to write PHP script to remove redundant code in WordPress header, wordpress redundancy_PHP tutorialNext article：Explanation on how to write PHP script to remove redundant code in WordPress header, wordpress redundancy_PHP tutorial