Insert variables in a table of a sqlite-database

[Jo Jomax]

If we want to insert some values in a table COMPANY of a database, it should be written as below:

//--- enter data to the table    if(!DatabaseExecute(db, "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1,'Paul',32,'California',25000.00); " ))      {       Print("DB: ", filename, " insert failed with code ", GetLastError());       DatabaseClose(db);       return;      }


Now if we want to insert a variable x=1 instead of 1, how can we do it?

I tried the following but it didn't  worked:

"INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES(?,?,?,?,?), (x,'Paul',32,'California',25000.00); "

[Osmar Sandoval Espinosa]

Try something like this:

int x = 1;
string name = "Paul";
int age = 32;
string address = "California";
double salary = 25000.00;

DatabaseBind(db,
   "INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (?,?,?,?,?)",
   x, name, age, address, salary);

I think this is more like an SQL problem than a mql5.

[Jo Jomax]

No it did not work again

[Osmar Sandoval Espinosa]

Check this article:

Simplifying Databases in MQL5 (Part 1): Introduction to Databases and SQL - MQL5 Articles

It has a part about inserting (sql).