[sqlite] Data type information for derived columns

2012-10-10 Thread jkp487-sql...@yahoo.com
New to SQLite. Is there a way to get column data type information for derived columns in a query or view? For example, if I have something like this: select Customer.LastName || Customer.FirstName as Fullname then no data type is returned for that column. I’m using Delphi to access the datab

Re: [sqlite] Data type information for derived columns

2012-10-10 Thread Clemens Ladisch
jkp487-sql...@yahoo.com wrote: > New to SQLite. Is there a way to get column data type information for > derived columns in a query or view? For example, if I have something like > this: > > select Customer.LastName || Customer.FirstName as Fullname > > then no data type is returned for that column

Re: [sqlite] Data type information for derived columns

2012-10-10 Thread Simon Slavin
On 10 Oct 2012, at 6:21pm, jkp487-sql...@yahoo.com wrote: > Is there a way to get column data type information for > derived columns in a query or view? For example, if I have something like > this: > > > select Customer.LastName || Customer.FirstName as Fullname > > > then no data type is

Re: [sqlite] Data type information for derived columns

2012-10-10 Thread Petite Abeille
On Oct 10, 2012, at 7:21 PM, jkp487-sql...@yahoo.com wrote: > New to SQLite. Is there a way to get column data type information for > derived columns in a query or view? For example, if I have something like > this: > > > select Customer.LastName || Customer.FirstName as Fullname cast perhap

Re: [sqlite] Data type information for derived columns

2012-10-11 Thread kyan
On Wed, Oct 10, 2012 at 8:21 PM, jkp487-sql...@yahoo.com wrote: > New to SQLite. Is there a way to get column data type information for > derived columns in a query or view? For example, if I have something like > this: > > > select Customer.LastName || Customer.FirstName as Fullname > > > then no