Thanks, I'll give it a try with version 3.0.8
__
Raymond Irving
--- John LeSueur <[EMAIL PROTECTED]> wrote:
> 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);
>
>
