Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

Thanks a lot ! Le 15/10/12 18:27, Joe Mistachkin a écrit : Vincent DARON wrote: There is now way to know if the query is on a View or a Table while generating the SQL. The core SQLite library has been enhanced to deal with this situation, here:

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

Vincent DARON wrote: > > There is now way to know if the query is on a View or a Table while > generating the SQL. > The core SQLite library has been enhanced to deal with this situation, here: http://www.sqlite.org/src/info/5526e0aa3c -- Joe Mistachkin

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

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

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

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

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

Vincent DARON wrote: > > http://pastebin.com/q2m5vJky > The double quotes are coming from the SQLite core native library. Run "sqlite3.exe :memory:" and execute the following commands: .mode columns .headers on CREATE TABLE TEST (id); CREATE VIEW TESTVIEW AS SELECT TEST.id FROM TEST; INSERT

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

Of course http://pastebin.com/q2m5vJky Best Regards, Vincent Le 12/10/12 14:24, Joe Mistachkin a écrit : Vincent DARON wrote: It seems the IDataReader.GetName(int i) method return name surrounded by double quotes for views. Example: For a table : "Id" For a view : "\"Id\"" Is it the

Re: [sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

Vincent DARON wrote: > > It seems the IDataReader.GetName(int i) method return name surrounded by > double quotes for views. > > Example: > > For a table : "Id" > For a view : "\"Id\"" > > Is it the expected behaviour ? > Do you have some example SQL and/or C# code that demonstrates this

[sqlite] System.Data.SQLite Field Name are surrounded by double quotes for Views

Hi all, It seems the IDataReader.GetName(int i) method return name surrounded by double quotes for views. Example: For a table : "Id" For a view : "\"Id\"" Is it the expected behaviour ? Thanks Vincent PS: In the same way, IDataReader.GetColumnIndex() will return -1 for view column name