@Alain Verleyen or @William Roeder, do either of you know if there is a query character limit in mt5's sqlite connector?
If so, I may need to use triggers as a workaround (which is ridiculous).
I've tested a bunch of valid sqlite queries on my db. When I try to execute the same queries from mt5, only the short queries execute, otherwise I get 5601 ERR_DATABASE_ERROR — generic error. (@Alain Verleyen I see that you posted about this error here https://www.mql5.com/en/forum/53/page20#comment_16518684)
I found out the problem. It seems that none of the JSON1 ( https://www.sqlite.org/json1.html ) commands are supported in mql5's sqlite connector.
It would be nice to see that integration in the future. For now... triggers it is.
- www.sqlite.org
![MQL5 - Language of trade strategies built-in the MetaTrader 5 client terminal](https://c.mql5.com/i/registerlandings/logo-2.png)
- Free trading apps
- Over 8,000 signals for copying
- Economic news for exploring financial markets
You agree to website policy and terms of use
@Alain Verleyen or @William Roeder, do either of you know if there is a query character limit in mt5's sqlite connector?
If so, I may need to use triggers as a workaround (which is ridiculous).
I've tested a bunch of valid sqlite queries on my db. When I try to execute the same queries from mt5, only the short queries execute, otherwise I get 5601 ERR_DATABASE_ERROR — generic error. (@Alain Verleyen I see that you posted about this error here https://www.mql5.com/en/forum/53/page20#comment_16518684)