Database Wrapper - MetaTrader 5 Library | MT5 EA Download - MetaTrader 5 Resources

c. Try to execute within a transaction to avoid some 5605 errors

This is a package library for the DatabaseXXX series of functions, which realizes the automatic release of resources.

 C database db( "test.db" ); //When the object life cycle ends, DatabaseClose is automatically called

print ( "database available=" , db.IsAvaliable());

 Print ( "Table" ,db.HasTable( "Tab" )? "Exists" : "Does not exist" );

 db.Execute("Create table tab(aa integer, bb double , cc string );"); for ( integer i = 1 ; i < 10 ; i++)
{

db.Execute( String format ("Insert (aa, bb, cc) value (%d, %G, %s);", i, rand ()/ 100 , SQLiteTimeStr( timecurrent ())));

}

 CDatabaseRequest req = db.Query( "Select * from tab" ); //When the object life cycle ends, DatabaseFinalize integer v is automatically called ;

Request.GetInteger( 0 , five); integer v2 = req.GetIntegerOrDefault( "Ah" );

 integer v;

double d; string s; boolean rc = db.QueryFirst< integer , double , string >(v, d, s, "Select * from tab" );

 integer v[]; double d[]; string s[]; boolean rc = db. Query < integer , double , string > (v, d, s, "Select * from tab" );

Attachment download

📎 database.mqh (131.18 KB)

📎 test.mq5 (4.08 KB)

Source: MQL5 #33299