private static String GetVersionCompareSQL(DBTable table, String compare_field, String compare_value)
{
return(String.Format(@" IF (SELECT ISNULL(COUNT(*),0) FROM {0} {1} AND CAST( {2} AS VARCHAR(1000)) = CAST( CAST( '{3}' AS datetime)AS VARCHAR(1000))) =0 BEGIN THROW 50000, 'The {0} version is not up to date. Please refresh the page.', 1; END ", table.table.Replace("'", ""), table.GenerateFilter(table.GetPrimaryValues()), compare_field.Replace("'", ""), compare_value.Replace("'", "''")));
}
