Hi Marshall, A good suggestion.
The reason I chose to "transform" the schema instead was that there are a number of databases with similar structure on different sites which has the same declared data types. Also there will be several more in the future. This is supported by a framework of some classes that I use to handle SQLite. The frame work has been updated so only those declared data types that work with Excel (i.e. Excel recognizes the data as the correct type and use sum and other numerical functions). Thus future databases would have only the "correct" declared data types. Rather than have some databases which need special handling with views I prefer to handle the situation once and for all in existing and future databases and not have to worry about having special views for some tables in some databases at certain sites. /Frank > -----Original Message----- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Marshall Cline > Sent: 18 October 2011 22:30 > To: General Discussion of SQLite Database > Cc: General Discussion of SQLite Database > Subject: Re: [sqlite] Changing the data type of an existing table > > I think you've already found a good solution to your problem by directly > modifying the master table, so this is mostly an academic curiosity, but would > it be a viable alternative to use a VIEW? In other words, rather than messing > with the TABLE that holds the data, could you simply create a VIEW that > exposes the information in the type you want (via a cast?), then your excel > can access the data via the VIEW rather than the TABLE? > > To reiterate, I'm merely asking about viability here. > > Marshall > > Sent from my iPhone > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users