1

 <span onmouseover="_tipon(this)" onmouseout="_tipoff()"><span class="google-src-text" style="direction: ltr; text-align: left">+ (int)intFromDatabase:(FMDatabase *)db query:(NSString *)queryString { int retVal = 0; FMResultSet *rs = [db executeQuery:queryString, nil]; if ([rs next]) { retVal = [rs intForColumnIndex:0]; } [rs close]; return retVal; } + (int)recordCountFromDatabase:(FMDatabase *)db fieldName:(NSString *)inFieldName tableName:(NSString *)inTableName whereClause:(NSString *)inWhereClause { return [Utils intFromDatabase:db query:[NSString stringWithFormat:@"select count(%@) as ctr from %@ where %@", inFieldName, inTableName, inWhereClause]]; } + (int)maxValueFromDatabase:(FMDatabase *)db fieldName:(NSString *)inFieldName tableName:(NSString *)inTableName whereClause:(NSString *)inWhereClause { int retVal = 0; NSString *sql = [NSString stringWithFormat:@"select max(%@) as maxval from %@ where %@", inFieldName, inTableName, inWhereClause]; FMResultSet *rs = [db executeQuery:sql, nil]; if ([rs next]) { retVal = [rs intForColumn:@"maxval"]; } [rs close]; return retVal; }</span> + (Int) intFromDatabase: (FMDatabase *) consulta db: (NSString *) queryString {int retval = 0; FMResultSet * rs = [db executeQuery: queryString, nil]; if ([rs siguiente]) {retval = [rs intForColumnIndex : 0];} [rs cerrar]; volver retval;} + (int) recordCountFromDatabase: (FMDatabase *) db fieldName: (NSString *) TableName inFieldName: (NSString *) inTableName whereClause: (NSString *) inWhereClause {return [Utilidades intFromDatabase: db consulta: [NSString stringWithFormat: @ "select count (% @) como CTR de% @ where% @", inFieldName, inTableName, inWhereClause]];} + (int) maxValueFromDatabase: (FMDatabase *) db fieldName: ( NSString *) TableName inFieldName: (NSString *) whereClause inTableName: (NSString *) inWhereClause {int retval = 0; NSString * sql = [NSString stringWithFormat: @ "select max (% @) como maxval de @% donde% @", inFieldName, inTableName, inWhereClause]; FMResultSet * rs = [db executeQuery: sql, nil]; if ([rs siguiente]) {retval = [rs intForColumn: @ "maxval"];} [rs cerrar]; volver retval;}</span>