How to insert a row dynamically into the DB
<p>I am trying to create a database where there will be records which will be dynamically inserted into the DB. When I am trying to insert the record using the following query, only first value is getting inserted. Not able to insert a complete record. I am able to do that when it is a combination such as string and int. But when I am trying to insert all string values into the record it is only taking the first string.
The query which I used is as follows:</p>

<p>"It is java file which consists of Creating Database,creating table and declare a method insert, to insert dynamically in another class by creating object for this class and using insert method by passing arguments"
     public DataHelper(Context context) 
       {
          this.context = context;
          OpenHelper openHelper = new OpenHelper(this.context);
          this.db = openHelper.getWritableDatabase();
          this.insertStmt = this.db.compileStatement(INSERT);
       }</p>

<pre><code>   public long insert(String name,String address,String country)
   {
      this.insertStmt.bindString(name, address, country);
      return this.insertStmt.executeInsert();
   }
</code></pre>

<p>"It is another java class where we will create object for above class and call the insert method by passing arguments"</p>

<pre><code>           private DataHelper dh;
           this.dh.insert("ravi","hyd","India");
</code></pre>

<p>Please suggest. I am currently stuck here in the project.</p>
