Re: [sqlite] Preventing TableNames.columns inside SELECT

2004-10-24 Thread Will Leshner
On Oct 24, 2004, at 2:59 PM, Raymond Irving wrote: I would like to only return the field names and not table.fieldnames... SELECT t1.column1,t2.clumn2 FROM tableA t1,table2 t2 Can't you just use "as": SELECT t1.column1 as column1, t2.column2 as column2 FROM tableA t1, table2 t2

[sqlite] Preventing TableNames.columns inside SELECT

2004-10-24 Thread Raymond Irving
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.

Re: [sqlite] Warnings during compilation

2004-10-24 Thread Will Leshner
On Oct 24, 2004, at 8:42 AM, Ng Pheng Siong wrote: So if people cast to make the compiler happy then people won't be nervous? ;-) Good point. I didn't word that very well. I guess what I'm thinking is that if you put in an explicit cast then you are indicating that you are well aware that

Re: [sqlite] Warnings during compilation

2004-10-24 Thread Ng Pheng Siong
On Sun, Oct 24, 2004 at 08:17:52AM -0700, Will Leshner wrote: > I'm assuming that in practice it is ok, but it does make some people > nervous. It might be good to explicitly cast the results of > floating-point math back to ints to make the compiler happy. So if people cast to make the compiler

[sqlite] Warnings during compilation

2004-10-24 Thread Steven Van Ingelgem
Hi, I just downloaded the sqlite sources (pre-build for windows & 3.0.8). Now during compilation I get this: 0 error(s), 539 warning(s) Is this normal? wxWidgets: CVS_HEAD OS:    WindowsXP/1 IDE:   MS Visual 6/5 pgppzHFOtJPY2.pgp Description: PGP signature