Function _hx_sqlite_request

src/hx/libs/sqlite/Sqlite.cpp:240–272

request : 'db -> sql:string -> 'result Executes the SQL request and returns its result **/

   <doc>Executes the SQL request and returns its result</doc>
**/
Dynamic _hx_sqlite_request(Dynamic handle,String sql)
{
   database *db = getDatabase(handle);

   int byteLength = 0;
   const char * sqlStr = sql.utf8_str(0, true, &byteLength);
   sqlite3_stmt *statement = 0;
   const char *tl = 0;
   __hxcpp_enter_gc_free_zone();
   int err = sqlite3_prepare(db->db,sqlStr,byteLength,&statement,&tl);
   __hxcpp_exit_gc_free_zone();
   if (err != SQLITE_OK)
   {
      hx::Throw( HX_CSTRING("Sqlite error in ") + sql + HX_CSTRING(" : ") +
                  String(sqlite3_errmsg(db->db) ) );
   }
   if( *tl )
   {
      __hxcpp_enter_gc_free_zone();
      sqlite3_finalize(statement);
      __hxcpp_exit_gc_free_zone();
      hx::Throw(HX_CSTRING("Cannot execute several SQL requests at the same time"));
   }

   int i,j;

   result *r = new result();
   r->create(db->db, statement,sql);

   db->setResult(r);

   return r;
}