Sorry guys dont knwo the code tags for the forum
below is the function i am using to insert data in the dataBase
where query is passed as the argument
getDBConnection is a function that returns the sqlConnection object
After inserting msgbox displays ra as "1"