Is there a sqlite query size limit?

New comment
 

@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)

List of changes in MetaTrader 5 Client Terminal builds
List of changes in MetaTrader 5 Client Terminal builds
  • 2019.12.07
  • www.mql5.com
List of changes in the Help for MQL5:Corrected description of the GlobalVariablesFlush() function , input parameters are not required, Length the c...
 
nightvision04:

@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.

The JSON1 Extension
  • www.sqlite.org
json( json ) json_array( value1 , value2 ,...) json_array_length( json ) json_array_length( json , path ) json_extract( json , path ,...) json_insert( json , path , value ,...) json_object( label1 , value1 ,...) json_patch( json 1,json2) json_remove( json , path ,...) json_replace( json , path , value ,...) json_set( json , path , value...
New comment