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.
Due to SQLite's dynamic typing, determining the data type of an expression is not possible in the general case. It's even possible to have table columns without declared types. > I’m using Delphi to access the database and Delphi’s field objects > throw a fit if they don’t have a data type. Then the driver you are using to connect SQLite to Delphi (whatever it is) is broken. (I'm using Delphi with SQLite, but this is an inhouse library not based on TDataSet.) Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
