I try to insert numeric values (as strings) into an SQLite DB using
Dim bql As String
bql = “INSERT INTO TBigl (Data, NBigl, Lord, Net, IVA) VALUES ( ‘c.D_DATA’, ‘c.N_BIGL’, ‘c.LORD_B’, ‘c.NET_B’, ‘c.IVA_D_B’ );” //Istruzioni specifiche di bqlite
where c.XXX are strings representing numerical values.
What I get is a row populated with the names c.XXX as in the attached picture.
How can I write the respective values instead of the names of the globals?