View Revisions: Issue #4354
| Summary | 0004354: MsSql - create trigger query fails when keys contain spaces | ||
|---|---|---|---|
| Revision | 2020-04-23 18:57 by elong | ||
| Additional Information | Line 17 of create_trigger_query.sql is if (1=1 AND ( UPDATE(Vendor No_) OR UPDATE(Item No_) OR UPDATE(Variant Code) ) ) <----- Created on start and not working but it should be if (1=1 AND ( UPDATE("Vendor No_") OR UPDATE("Item No_") OR UPDATE("Variant Code") ) ) <----- Working |
||
| Revision | 2020-04-17 12:28 by StrDevelopment | ||
| Additional Information | Line 17 of create_trigger_query.sql is if (1=1 AND ( UPDATE(Vendor No_) OR UPDATE(Item No_) OR UPDATE(Variant Code) ) ) <----- Created on start and not working but it should be if (1=1 AND ( UPDATE("Vendor No_") OR UPDATE("Item No_") OR UPDATE("Variant Code") ) ) <----- Working |
||