Kornel comments

Repositories
Issues
Comments

Results 1 comments of


                                            Kornel

AnsiSqlGenerator causes SQL syntax error for "where ... in (new select...)" statement

how to fix: in ANSISqlGenerator.cs > virtual string BuildPagedSelectStatement() change string tweakedWheres = wheres.Replace("WHERE", "AND"); to: string tweakedWheres = Sugar.Strings.ReplaceFirst(wheres, "WHERE", "AND", StringComparison.OrdinalIgnoreCase); and add to sugar > String new...