[sqlite] Store the value from a variable into a field in database table

[Krishnajith S S]

How can I store the data from a variable into a field in the database
table?

For eg:

int z = 50;

How to insert the data in z into a field in table?

sql = "INSERT INTO TABLE (ID, DATA)" \
         "VALUES (1, z)" ;";

The above doesn't work. Please help.