- Fixed bug parsing field names returned by SQLite

pborissow · pborissow · commit 98e2b7b92b9c · 2015-07-20T20:56:29.000Z
git-svn-id: svn://192.168.0.80/JavaXT/javaxt-core@695 2c7b0aa6-e0b2-3c4e-bb4a-8b65b6c465ff
diff --git a/src/javaxt/io/Image.java b/src/javaxt/io/Image.java
@@ -1514,7 +1514,7 @@ private String getExtension(String FileName){
   //** hasColor
   //**************************************************************************
   /** Used to determine whether a given pixel has a color value. Returns false
-   *  if the pixel is white or transparent.
+   *  if the pixel matches the input color or is transparent.
    */
     private boolean hasColor(int pixel, int red, int green, int blue){
 
diff --git a/src/javaxt/sql/Field.java b/src/javaxt/sql/Field.java
@@ -30,6 +30,25 @@ protected Field(int i, java.sql.ResultSetMetaData rsmd){
          try{ Schema = getValue(rsmd.getSchemaName(i)); } catch(Exception e){}
          try{ Type = getValue(rsmd.getColumnTypeName(i)); } catch(Exception e){}
          try{ Class = getValue(rsmd.getColumnClassName(i)); } catch(Exception e){}
+
+         
+       //Special case. Discovered that the column name was returning a 
+       //table prefix when performing a union quiries with SQLite
+         if (Name!=null && Name.contains(".")){
+            String[] arr = Name.split("\\.");
+            if (arr.length==3){
+                Name = arr[2];
+                Table = arr[1];
+                Schema = arr[0];
+            }
+            else if (arr.length==2){
+                Name = arr[1];
+                Table = arr[0];
+            }
+            else if (arr.length==1){
+                Name = arr[0];
+            }
+         }
     }
 
 
