Re: [sqlite] Preventing TableNames.columns inside SELECT

[John LeSueur]

Raymond Irving wrote:
Hi All,
Please consider the following example:
I would like to only return the field names and not
table.fieldnames...
SELECT t1.column1,t2.clumn2
FROM tableA t1,table2 t2
..In MSSQL and others the recordset should only show
column1, column2 but in SQLite it shows t1.column1 and
t2.column2. How can I
How do I configure SQLite to only return  the field
(or column) names?
__
Raymond Irving
 

Are you using sqlite 2.x? If so, there is a little change below that can 
fix it, and I think for 3.x it's already been changed. 
At least I was told so.  I really hope so, because I get tired of using 
AS all the time.  With the following patch, just set
pragma short_column_names to be 1 and sqlite will return column names 
formatted just like every other database.

John Lesueur
diff -NU3 -r ./select.c ../../sqlite-orig/src/select.c
--- ./select.c    2004-06-19 11:31:48.778990400 -0600
+++ ../../sqlite-orig/src/select.c    2004-06-17 13:03:38.000000000 -0600
@@ -739,7 +739,7 @@
        sqlite3SetString(&zName, zTab, ".", zCol, 0);
        sqlite3VdbeSetColName(v, i, zName, P3_DYNAMIC);
      }else{
-        sqlite3VdbeSetColName(v, i, zCol, P3_STATIC);
+        sqlite3VdbeSetColName(v, i, zCol, 0);
      }
    }else if( p->span.z && p->span.z[0] ){
      sqlite3VdbeSetColName(v, i, p->span.z, p->span.n);