rucc | rucc is a tiny toy C compiler in Rust | Compiler library
kandi X-RAY | rucc Summary
kandi X-RAY | rucc Summary
rucc is a small toy C compiler implemented in Rust.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of rucc
rucc Key Features
rucc Examples and Code Snippets
Community Discussions
Trending Discussions on rucc
QUESTION
I want to create a trigger that let me delete a row from the table 'DETALLES' and after deleting that specific row I want to modify another table called "BOLETAS" and another called "ARTICULOS", the first table it's like this:
And for example I want to delete a row from this table, after that this second table called "ARTICULOS":
!
must update his "STOCK" with the amount that is recovered because of the deleted row from the table "DETALLES" column "CANTIDAD" and finally the table called "BOLETAS":
must update the column "TOTAL" less the amount deleted from the table "DETALLES" column "IMPORTE".
So basically, there must be a Trigger that let me delete a row from the table "DETALLES" and update another 2 tables.
For example I decide to delete the second row from "DETALLES" and so the table "ARTICULOS" column "STOCK" of 'ART002' must be plus 1 because of the column "CANTIDAD" and the table "BOLETAS" must be less "60". I tried it for hours but I can't, Sorry for my bad english :( Those are the codes that I used to create the tables.
...ANSWER
Answered 2017-Nov-05 at 16:13I played around with your tables and sample data. From the testing I did, it will work with only 1 row deleted or multiple rows deleted. You should do some more testing to verify, but I believe this should work with the data and logic you described.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install rucc
Rust is installed and managed by the rustup tool. Rust has a 6-week rapid release process and supports a great number of platforms, so there are many builds of Rust available at any time. Please refer rust-lang.org for more information.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page