converting sqlce methods to sqlite