View Revisions: Issue #4354
| Summary | 0004354: MsSql - create trigger query fails when keys contain spaces | ||
|---|---|---|---|
| Revision | 2020-04-17 12:28 by StrDevelopment | ||
| Description | We use Microsoft Dynamics Nav. Most of the NAV table and fieldnames contain spaces...... When the symmetric server starts/updates, triggers are (re)created. If the key(s) contain spaces the query will fail because double qoutes are missing in one line of the create trigger query. |
||
| Revision | 2020-04-23 18:57 by elong | ||
| Description | We use Microsoft Dynamics Nav. Most of the NAV table and fieldnames contain spaces...... When the symmetric server starts/updates, triggers are (re)created. If the key(s) contain spaces the query will fail because double qoutes are missing in one line of the create trigger query. |
||
| Revision | 2020-04-17 12:28 by StrDevelopment | ||
| Steps To Reproduce | Import DB.xml via Dbimport. Add to sym_channel, sym_trigger and sym_trigger_router. The logs will show it fails after a few seconds. if you run the trigger query manually with double quotes, it will work, untill you reboot or add another trigger. |
||
| Revision | 2020-04-23 18:57 by elong | ||
| Steps To Reproduce | Import DB.xml via Dbimport. Add to sym_channel, sym_trigger and sym_trigger_router. The logs will show it fails after a few seconds. if you run the trigger query manually with double quotes, it will work, untill you reboot or add another trigger. |
||
| 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 |
||
| 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 |
||