Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.
Sign upSQL syntax control, specifically on Trigger code editors #3592
Comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Details
OK button not enabling after TRIGGER code fixing, unless I go to the end of line and write ";".
Steps to reproduce
(1) Error on row commit: the table has triggers.
(2) Another table is not found in trigger code (because it couldn't be updated automatically and forgot to review it myself as the program warns).
(3) Fix the trigger code at the point where that lost table is (but OK won't enable).
(4) Go to the very end of code, delete and rewrite the semicolon. (OK button enables)
Notes
On changing names to columns or tables, triggers and views do not update entirely. To be specific this happens after FROM or WHERE clauses of TRIGGERS and VIEWS.
Versions
3.2.1 on Wine 4.0