[sqlite] sqlite db2 error in symbian

[rahul . makode]

i am writing this query to insert data in symbian but i am getting
err1=-311 and sqldb2 error in symbia


{

TInt err1 =stmt.Prepare(db,_L("INSERT INTO
MyContacts(ServerContactID,UserName,FirstName,LastName,Country,IsBlocked,RequestStatus,MarkForDeletion)
VALUES(:ServerContactID,:UserName,:FirstName,:LastName,:Country,:IsBlocked,:RequestStatus,:MarkForDeletion)"));
                        
//,:TimeStamp,:MobileNumber,:OfficePh,:Address1,:Address2,:Email,:HomePh

                        error.AppendNum(err1);

                        iChitDemoAppUi->Log(_L8("error code "));

                        iChitDemoAppUi->Log(error);

                        TInt paramIndex1 = 
stmt.ParameterIndex(_L(":ServerContactID"));


                        TInt paramIndex2 = stmt.ParameterIndex(_L(":UserName"));
                        TInt paramIndex3 = 
stmt.ParameterIndex(_L(":FirstName"));
                        TInt paramIndex4 = stmt.ParameterIndex(_L(":LastName"));
                        TInt paramIndex5 = stmt.ParameterIndex(_L(":Country"));
                        TInt paramIndex6 = 
stmt.ParameterIndex(_L(":IsBlocked"));
                        TInt paramIndex7 = 
stmt.ParameterIndex(_L(":RequestStatus"));
                        TInt paramIndex8 = 
stmt.ParameterIndex(_L(":MarkForDeletion"));


                        err1= stmt.BindInt(paramIndex1,userID);

                        error.AppendNum(err1);

                        iChitDemoAppUi->Log(_L8("error code  "));

                        iChitDemoAppUi->Log(error);

                        iChitDemoAppUi->Log(_L8("inside addContacts "));
                        err1 = stream.BindText(stmt, paramIndex2);
                        temp.Append(username);
                        stream.WriteL(temp);
                        temp.Zero();
                        stream.Close();

                        err1 = stream.BindText(stmt, paramIndex3);
                        temp.Append(firstName);
                        stream.WriteL(temp);
                        temp.Zero();
                        stream.Close();

                        err1 = stream.BindText(stmt, paramIndex4);
                        temp.Append(LastName);
                        stream.WriteL(temp);
                        temp.Zero();
                        stream.Close();

                        err1 = stream.BindText(stmt, paramIndex5);
                        temp.Append(CountryName);
                        stream.WriteL(temp);
                        temp.Zero();
                        stream.Close();

                        err1= stmt.BindInt(paramIndex6, isBlocked);

                        err1 = stream.BindText(stmt, paramIndex7);
                        temp.Append(requestStatus);
                        stream.WriteL(temp);
                        temp.Zero();
                        stream.Close();

                        err1= stmt.BindInt(paramIndex8,markForDeletion);

                        
//TimeStamp,MobileNumber,OfficePh,Address1,Address2,Email,HomePh

                        err1 = stmt.Exec();
                        stream.Close();
                        stmt.Reset();

}


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users