litesoft

Explore

Commits

Diff Revisions 150 vs 151 for /trunk/Java/core/Server/src/org/litesoft/sql/SQLProductSpecificHelperMicrosoft_SQL_Server.java

		@@ -16,7 +16,7 @@
16	16		int at = pProductVersion.indexOf( '.' );
17	17		switch ( at )
18	18		{
19		-	case-1:
	19	+	case -1:
20	20		break;
21	21		case 0:
22	22		return -1;
		@@ -50,14 +50,12 @@
50	50		{
51	51		if ( extractMajorVersion( pProductVersion ) < 9 )
52	52		{
53		-	throw new UnsupportedOperationException( "Microsoft SQL Server version " + pProductVersion +
54		-	" does NOT support OFFSET &/ LIMIT or the ROW_NUMBER() function. You must use a stored procedure!" );
	53	+	throw new UnsupportedOperationException( "Microsoft SQL Server version " + pProductVersion + " does NOT support OFFSET &/ LIMIT or the ROW_NUMBER() function. You must use a stored procedure!" );
55	54		}
56	55		return "SELECT" + //
57	56		" " + pSelectColumns + //
58	57		" FROM " + // ROWNUM is 1 based
59		-	" (SELECT ROW_NUMBER() OVER(" + pOrderBy + ") AS zOurTempRowNum, * FROM " + pTableName +
60		-	" " + pSelectionWhereClause + ") a" + //
	58	+	" (SELECT ROW_NUMBER() OVER(" + pOrderBy + ") AS zOurTempRowNum, * FROM " + pTableName + " " + pSelectionWhereClause + ") a" + //
61	59		" WHERE zOurTempRowNum > " + pOffset + " AND zOurTempRowNum <= " + (pOffset + pLimit) + //
62	60		" ORDER BY zOurTempRowNum";
63	61		}
		@@ -79,8 +77,7 @@
79	77		}
80	78
81	79		@Override
82		-	public boolean columnExists( Connection pConnection, DBinfo pDBinfo, String pTableName,
83		-	String pColumnName )
	80	+	public boolean columnExists( Connection pConnection, DBinfo pDBinfo, String pTableName, String pColumnName )
84	81		throws SQLException, MultipleTablesException
85	82		{
86	83		return LLcolumnExists( pConnection, pDBinfo, pTableName, pColumnName, //