title: How to insert integer value into SQLite table at Delphi
body: <p>I am trying to insert integer value in my <code>SQLite</code> table at Delphi.<br>
  In table <code>emp</code> <code>usergroup_id</code> is integer and <code>label</code>, <code>description</code> are string data type.<br>
  My code is as follows:  </p>
  
  <pre><code>var
    gid: Integer;
    sdescription,ldescription: String;
  begin
    sdescription := RzEdit1.Text;
    ldescription := RzMemo1.Text;
    gid := Integer(RzComboBox1.Items.Objects[RzComboBox1.Items.IndexOf(gname)]);
  
    try
      SQLConnection1.Connected := true;
      SQLMonitor1.Active := True;
      sSql := 'INSERT INTO emp(usergroup_id, label, description) VALUES (gid,''' + sdescription + ''',''' + ldescription + ''' )';
      SQLConnection1.ExecuteDirect(sSql);
  
    except
      on E: EDatabaseError do
        ShowMessage('Exception raised with message' + E.Message);
    end;
  end;
  </code></pre>
  
  <p>It is giving me an error as <code>Unknown column gid</code>.<br>
   When I tried something like this with fixed integer value instead of variable it works:  </p>
  
  <pre><code>sSql := 'INSERT INTO emp(usergroup_id, label, description) VALUES (1,''' + sdescription + ''',''' + ldescription + ''' )';
  </code></pre>
  
  <p>It inserts values successfully into table.<br>
   How to insert integer value of <code>gid</code> into database with above query. What would be the proper format?</p>