Insert integer data

[Rangasql]

I am trying to insert integer values to mysql database using the integer variable declared in C++ language, but it is not inserting . it is inserting zeroes , but not the values in the variable. Can any one please tell me how to do it, It is very very urgent
code snippet is given below.

p is declared as integer

 void BarCode::OnBtnApplyClicked()
{
 
 
        int p = expDateSpin_btnStart.get_value_as_int();
        Glib::ustring  s="ExpiredDate";
        flag=true;
        for(int i=0;i<num_rows;i++)
        {
                dbase_obj.fetch_row();
                if(dbase_obj.row[1] == entry1.get_text())
                {
                     flag=false;
                     break;
                }
                else
 
                  flag=true;
 
        }
        if(flag)
 
 
        dbase_obj.get_connection(" INSERT into tblBarcodeRuleItem(CatNo,FieldName,Start)values ('"+entry3.get_text()+"','"+s+"', '"+p+"') " );
 
}

[r035198x]

I am trying to insert integer values to mysql database using the integer variable declared in C++ language, but it is not inserting . it is inserting zeroes , but not the values in the variable. Can any one please tell me how to do it, It is very very urgent
code snippet is given below.

p is declared as integer

 void BarCode::OnBtnApplyClicked()
{
 
 
        int p = expDateSpin_btnStart.get_value_as_int();
        Glib::ustring  s="ExpiredDate";
        flag=true;
        for(int i=0;i<num_rows;i++)
        {
                dbase_obj.fetch_row();
                if(dbase_obj.row[1] == entry1.get_text())
                {
                     flag=false;
                     break;
                }
                else
 
                  flag=true;
 
        }
        if(flag)
 
 
        dbase_obj.get_connection(" INSERT into tblBarcodeRuleItem(CatNo,FieldName,Start)values ('"+entry3.get_text()+"','"+s+"', '"+p+"') " );
 
}

Is the p value correct? Have you tried printing it with a simple cout or something similar?

[Rangasql]

Yes p contains and prints whatever that is entered in the text box