18. Re: Sqlite, Is it possible to calculate the length of the
> longest increasing subsequence using an UDF?
> (Elefterios Stamatogiannakis)
Elefterios Stamatogiannakis, Thank you for your thoughtful analysis of
calculating the length of the longest increasing subsequence
> 5. Re: Sqlite, Is it possible to calculate the length of the
> longest increasing subsequence using an UDF? (Igor Tandetnik)
Igor Tandetnik, Thank you for very helpful reply to our question. I
will have to wait until Monday to ask the project director what the actual
purpose of
Ok I found a solution a week ago. It was really simple to do:
ModelEntities1 ModelData = new ModelEntities1(connString.ConnectionString);
ModelData.Connection.Open();
ModelData.ExecuteStoreCommand("PRAGMA foreign_keys = ON");
EF has its own open and close connecti
And if you don't quote the 2nd select it comes out OK. This is 3.6.13:
sqlite> SELECT "id" FROM "TESTVIEW"; -- Observe the results here.
"id"
--
test
sqlite> SELECT id FROM "TESTVIEW"; -- Observe the results here.
id
--
Presumably a simple bug for the powers-to-be to fix.
Michael
I am out of the office until 10/22/2012.
I'm out of the office but checking email once a day and will respond to any
high importance issues as quickly as possible.
Note: This is an automated response to your message "sqlite-users Digest,
Vol 58, Issue 13" sent on 10/13/2012 10:00:02 AM.
This
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 INT
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 expec
Sorry for hijacking the thread, but i have an answer for that.
IMHO having the computation application and the data management on
different domains incurs a very high data transfer cost.
The traditional thinking of shipping the data from the DB to somewhere
else (application code) to do the c
8 matches
Mail list logo