[Squirrel-sql-commits] SF.net SVN: squirrel-sql:[6252] trunk/sql12/fw/src/main/java/net/ sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

[<man...@us...>]

Revision: 6252
          http://squirrel-sql.svn.sourceforge.net/squirrel-sql/?rev=6252&view=rev
Author:   manningr
Date:     2011-05-10 12:52:27 +0000 (Tue, 10 May 2011)

Log Message:
-----------
removed qualifier from indexName as progress calls this a syntax error.

Modified Paths:
--------------
    trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

Modified: trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java
===================================================================
--- trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-09 21:34:32 UTC (rev 6251)
+++ trunk/sql12/fw/src/main/java/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java	2011-05-10 12:52:27 UTC (rev 6252)
@@ -594,7 +594,11 @@
 			result.append("UNIQUE ");
 		}
 		result.append(" INDEX ");
-		result.append(DialectUtils.shapeQualifiableIdentifier(indexName, qualifier, prefs, this));
+		// Progress version 10.1C yields the following error for a qualified index name:
+		//   [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or 
+		//   about ".testIndex ON MANNINGR.CREATEINDEXTEST(IDXTESTCOLUMNNAME)
+		//result.append(DialectUtils.shapeQualifiableIdentifier(indexName, qualifier, prefs, this));
+		result.append(indexName);
 		result.append(" ON ");
 		result.append(DialectUtils.shapeQualifiableIdentifier(tableName, qualifier, prefs, this));
 		result.append("(");


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.