[sqlite] Run sqlite from a batch file

Hi All, I am trying to execute MS DOS batch file from C# code using system.diagnostics to run a sequence of sqlite3 commands to output query results in a '.csv' file. MyBatch.bat contains... sqlite3 mydb.db a.txt echo test c:\test.txt a.txt contains... .mode csv .separator , .output

[sqlite] unique combination of concatenated column query

Hi, All. Could you, please, help me with sql query ? For example, if I have a table1 like the following (fields/values separated by commas): component, bin, prd 2.1, 1, 217 6.5, 4, 217 7.1 ,3, 217 7.6 ,5, 217 7.7,5, 217 1.3 ,2, 217 1.1,1,

[sqlite] Re; Subrank query

Dear Friends, please help with sqlite query, i have a table like: score| rank | game 98| 1 |1615 98| 1 |1615 92| 2 |1615 87| 3 |1615 87| 3 |1615 87| 3 |1615 112 | 1 |1616 94| 2 |1616 94| 2

Re: [sqlite] User Defined Function using P/Invoke SQLite wrappers

Hi All, I have an assignment to do statistical processes in C#. I like SQLite stand-alone feature but I need to be able to do the assignment using something like SQL Server stored-procedure. I was wondering if someone could give me a simple straight forward example of creating user defined

[sqlite] Table inserts take a long time to complete.

Hi All, I would very much appreciate if someone could help me speed up my database table insertion process as what I have in the followings took a long time to complete even when using sqlite3 shell command. Thank you in advance for your help. Cheers, Rick CREATE TABLE [BuyPattern] ( [ID]

[sqlite] sqlite3.dll wrapper to import .csv file

Hi All, I am using sqlite3.dll in my c# winform app, I was wondering if anyone knows how to import .csv file into sqlite db table using c# sqlite3.dll wrapper function. Thank's for any help I get. Cheers, Rick ___ sqlite-users mailing list

[sqlite] Can we access table column using field and index instead of name?

Hi, would it be possible to reference a column in a table using other than its name? For example, if I have : create table X ( a TEXT NOT NULL); would it be possible to access x.a with something similar as x.field[0]? Thank's. ___ sqlite-users mailing

Re: [sqlite] SQLite Random Sampling

Hi All, I need help with speeding up my samples collection which is processed using C# codes and SQLite. I am doing a random sampling experiment using sqlite to find the most dominant types of lab. findings. We have about 26 years of lab experiments data provided in a table such as: CREATE TABLE

[sqlite] SQLite Random number generator

Hi All, how do you generate a random number between two numbers in your query using the random() function? Thank's. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Table insert takes very long time, please help..

Hi all, I have the following tables: CREATE TABLE [a] ( [ItemType] VARCHAR(10) NOT NULL, [Item] VARCHAR(60) NOT NULL, [LastDate] DATE NOT NULL, [NextDate] DATE NOT NULL, [Probability] FLOAT NOT NULL, [Frequency] INTEGER NOT NULL, [TotalFrequency] INTEGER NOT NULL ) CREATE TABLE [b] ( [ID]

Re: [sqlite] Table insert takes very long time, please help..

edit: I need to mention that BEGIN and COMMIT were already included in my insert. On Fri, Dec 30, 2011 at 10:53 PM, Rick Guizawa guizaw...@gmail.com wrote: Hi all, I have the following tables: CREATE TABLE [a] ( [ItemType] VARCHAR(10)  NOT NULL, [Item] VARCHAR(60)  NOT NULL, [LastDate] DATE