public static String _creabd(anywheresoftware.b4a.BA _ba) throws Exception { String _ssql = ""; // BA.debugLineNum = 9;BA.debugLine="Sub CreaBD"; // BA.debugLineNum = 10;BA.debugLine="Mi_BD.Initialize(File.DirInternal,\"DBApp.db\",True)' Se // crea el archivo en el directorio interno del Smartphone"; _mi_bd.Initialize( anywheresoftware.b4a.keywords.Common.File.getDirInternal(), "DBApp.db", anywheresoftware.b4a.keywords.Common.True); // BA.debugLineNum = 12;BA.debugLine="Dim sSql As String"; _ssql = ""; // BA.debugLineNum = 14;BA.debugLine="Try"; try { // BA.debugLineNum = 15;BA.debugLine="sSql = \"CREATE TABLE IF NOT EXISTS REVIEW \""; _ssql = "CREATE TABLE IF NOT EXISTS REVIEW "; // BA.debugLineNum = 16;BA.debugLine="sSql = sSql & \"(id_review INTEGER PRIMARY KEY // AUTOINCREMENT, \""; _ssql = _ssql + "(id_review INTEGER PRIMARY KEY AUTOINCREMENT, "; // BA.debugLineNum = 17;BA.debugLine="sSql = sSql & \"titulo TEXT, \""; _ssql = _ssql + "titulo TEXT, "; // BA.debugLineNum = 18;BA.debugLine="sSql = sSql & \"nota TEXT, \""; _ssql = _ssql + "nota TEXT, "; // BA.debugLineNum = 19;BA.debugLine="sSql = sSql & \"tipo TEXT, \""; _ssql = _ssql + "tipo TEXT, "; // BA.debugLineNum = 20;BA.debugLine="sSql = sSql & \"fecha_registro TIMESTAMP DEFAULT // CURRENT_TIMESTAMP)\""; _ssql = _ssql + "fecha_registro TIMESTAMP DEFAULT CURRENT_TIMESTAMP)"; // BA.debugLineNum = 21;BA.debugLine="Mi_BD.ExecNonQuery(sSql)"; _mi_bd.ExecNonQuery(_ssql); } catch (Exception e15) { (_ba.processBA == null ? _ba : _ba.processBA) .setLastException( e15); // BA.debugLineNum = 23;BA.debugLine="Log(\"catch ERROR CREATE TABLE IF NOT // EXISTS REVIEW: \"&LastException.Message)"; anywheresoftware.b4a.keywords.Common.Log( "catch ERROR CREATE TABLE IF NOT EXISTS REVIEW: " + anywheresoftware.b4a.keywords.Common.LastException(_ba).getMessage()); } ; // BA.debugLineNum = 25;BA.debugLine="End Sub"; return ""; }