Joe,
The problem is the following, I'm using and Orm Framework
(ServiceStack.OrmLite namely). The query are generated, and double
quoted are added automatically.
There is now way to know if the query is on a View or a Table while
generating the SQL.
It definitely looks like a bug in SQLite to me. What do you think ?
Thanks for info and help
Vincent
Le 14/10/12 18:26, Joe Mistachkin a écrit :
Vincent DARON wrote:
Does it mean that it's the expected behaviour of SQLite ?
I think so, yes. Technically, the double quotes supplied in the original
SELECT query were superfluous. If you remove them, they will not be present
in the results.
Would it be possible for System.Data.SQLite to remove these double
quotes if present, as they are not required any more once you have a C#
string ?
Possible, yes. Likely, no. System.Data.SQLite strives to return exactly
what it is given by SQLite, to the maximum extent possible.
--
Joe Mistachkin
_______________________________________________
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
