dingmaotu / mql-sqlite3 Goto Github PK

how solve error database is locked,
pls help me

@dingmaotu
Hi Ding,
Great work! 🥇
Do you think you can also add an example script or EA to put live ticks into the SQLite3 DB?

2020.01.05 21:18:46.845 TestSQLite3 AUDUSDm#,H4: unresolved import function call
2020.01.05 21:18:46.845 Cannot call 'sqlite3.dll::sqlite3_initialize', DLL is not allowed
2020.01.05 21:18:46.844 TestSQLite3 AUDUSDm#,H4: initialized

You say in the readme that the DLL should go into the Library directory, but you don't say where that is ocated.
MT4 only has a Libraries directory located under:
"C:\Users\<Username>\AppData\Roaming\MetaQuotes\Terminal\<hash>\MQL4\Libraries\.

So what is it?

I am using build 1280 of mt4 and I ran into this wierd problem, im not sure if its just me or it will effect others but i wanted to post my (dodgy) fix if anyone else runs into it. Any time i used getColumn on a table field that was larger than around 120characters or used getExtendedSql and the query was over 120 chars long i was getting a blank return value. Im no c programer but i dug around and worked out a dodgy fix just to get me out, I made a single line addition to StringFromUtf8Pointer in Common.mqh after the second call to MultiByteToWideChar.

string StringFromUtf8Pointer(intptr_t psz,int len)
  {
   if(len < 0) return NULL;
   string res;
   int required=MultiByteToWideChar(CP_UTF8,0,psz,len,res,0);
   StringInit(res,required);
   int resLength = MultiByteToWideChar(CP_UTF8,0,psz,len,res,required);
   res = StringFormat("%s",res);
   if(resLength != required)
     {
      return NULL;
     }
   else
     {
      return res;
     }
  }

Im no C programer and i have very little idea of what im doing so im unsure what caused this (maybe the copied string in memory doesnt quite jazz with mt4 perfectly) but my hack seems to have fixed it