Re: [sqlite] Preventing TableNames.columns inside SELECT
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
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
Re: [sqlite] Warnings during compilation
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 there is type conversion going on and that it isn't a problem. If you leave the explicit cast off and the compiler warns about the type conversion, then people might think that something is wrong when in fact nothing is wrong.
Re: [sqlite] Warnings during compilation
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 happy then people won't be nervous? ;-) -- Ng Pheng Siong <[EMAIL PROTECTED]> http://sandbox.rulemaker.net/ngps -+- M2Crypto, ZServerSSL for Zope, Blog
[sqlite] Warnings during compilation
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
