Simon, System.Data.Sqlite integration in visual studio has a database manager. You can use it to create databases/views/tables and also to design queries for table adapters and all kinds of nice things.
As stated in my original example, my database is currently encrypted and therefore I can not use the console version of sqlite. The specific issue has to do with an error that comes up in the integrated query designer for visual studio 2010, although I am sure that it is not isolated to 2010. I found a link to a post on sqlite.phxsoftware.com/forums that addresses this, but the link is currently broken. And a browse to the domain sqlite.phxsoftware.com has the same issue. Thanks, Tim On Tue, Apr 24, 2012 at 1:03 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Apr 2012, at 5:35pm, Tim Tessier <ttess...@swhistlesoft.com> wrote: > > > I am sure this question has been asked before, but there appears to be an > > issue with applying the || character in a view or select statement in > order > > to concat two columns in the output. > > > > Table Example > > > > Column1 Column2 > > this that > > then its > > > > SELECT Column1 || ' ' || Column2 as Column FROM TableExample > > > > In my specific example I am trying to concat a first name and last name > > into a fullname. I would simply create my own view with the console > app,but > > i appear to have encrypted this. > > 163:~ simon$ sqlite3 ~/Desktop/temp.sql > SQLite version 3.7.10 2012-01-03 21:54:09 > Enter ".help" for instructions > Enter SQL statements terminated with a ";" > sqlite> CREATE TABLE myTable (id INTEGER, Column1, Column2); > sqlite> INSERT INTO myTable VALUES (1, 'this', 'that'); > sqlite> INSERT INTO myTable VALUES (2, 'then', 'its'); > sqlite> SELECT Column1 || ' ' || Column2 FROM myTable; > this that > then its > sqlite> > > What's your problem ? > > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
