Re: [sqlite] Left Join

2008-11-27 Thread Igor Tandetnik
"Tommy Anderson" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Select * From ExcelMapValue > > OUTER JOIN (SELECT ProjectId, InputId, DataValue, Formula > FROM ProjectData > WHERE (ProjectId = @Id)) derivedtbl_1 > > On ExcelMapValue.InputId =

Re: [sqlite] how do this stuff in sqlite

2008-11-27 Thread Griggs, Donald
Rachmat, I also noted that one of your queries includes: time_to_sec(timediff(akhir1.End, awal1.Begin)) I think time conversion routines are part of each database vendor's implementation -- and not part of the sql standard, so you'll need to convert to the time routines provided in sqlite

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Sherief N. Farouk
> The given code is correct. The lower-case string is a C# alias for the > System.String class. System.Int64 is an opaque 64-bit pointer value. Seems like the grasping deficiencies are on my side :D. > The code so far is correct. What is missing though is the calling > convention, which by

Re: [sqlite] Loading database from memory buffer

2008-11-27 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brown, Daniel wrote: > What will happen if I don't implement the locking functionality does > that mean that SQLite would no longer be thread safe? It means that concurrent access (from different sqlite3 pointers in the same or different processes)

[sqlite] Left Join

2008-11-27 Thread Tommy Anderson
Hi, I have a left join problem with SQLite. this Select SELECT ProjectId, InputId, DataValue, Formula FROM ProjectData WHERE (ProjectId = @Id) contains almost 15 000 rows. this Table ExcelMapValue contains almost 5 000 rows. and contains these columns InputId, sheetCode,

Re: [sqlite] Loading database from memory buffer

2008-11-27 Thread Brown, Daniel
What will happen if I don't implement the locking functionality does that mean that SQLite would no longer be thread safe? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Roger Binns Sent: Thursday, November 27, 2008 12:05 PM To: General Discussion of

Re: [sqlite] Loading database from memory buffer

2008-11-27 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Brown, Daniel wrote: > However writing a new VFS would > seem to be quite an time consuming solution, If you don't have to worry about implementing the locking functionality (ie multi-threaded/process access) then doing your own VFS is very easy.

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Michael Ruck
The given code is correct. The lower-case string is a C# alias for the System.String class. System.Int64 is an opaque 64-bit pointer value. The code so far is correct. What is missing though is the calling convention, which by default is cdecl, but .NET doesn't use that one by default for

Re: [sqlite] Window functions

2008-11-27 Thread Elefterios Stamatogiannakis
I'm using sqlite's count function to emulate OLAP functionality. Unfortunately count function is not exposed in sqlite, nevertheless it eases the pain of not having analytics functions in sqlite (lead, lag, median etc). lefteris Alexey Pechnikov wrote: > Hello! > > В сообщении от Monday 24

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Sherief N. Farouk
> I am calling now this: > > [DllImport("sqlite3.dll", CharSet = CharSet.Unicode)] > internal static extern System.Int64 sqlite3_open16(string > filename, out IntPtr handle); > > I now finds an entry point, but i returned to the previous error: > An attempt was made to read

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Ti Ny
I am calling now this: [DllImport("sqlite3.dll", CharSet = CharSet.Unicode)] internal static extern System.Int64 sqlite3_open16(string filename, out IntPtr handle); I now finds an entry point, but i returned to the previous error: An attempt was made to read program in

Re: [sqlite] sqlite3_open16 fails on Windows Vista 64b

2008-11-27 Thread Ti Ny
New version of DW fixed that. The entry point is not present. All is built in 64bit but there seems to ne no entry point, no functions etc. Everything fails to load. I compile sqlite3.c Ti Ny > Date: Wed, 26 Nov 2008 16:54:56 -0500 > From: [EMAIL PROTECTED] > To: sqlite-users@sqlite.org >

Re: [sqlite] Database file size

2008-11-27 Thread Jens Miltner
Am 27.11.2008 um 09:12 schrieb Simon Bulman: > I have been playing around with SQLite to use as an alternative to > one of > our proprietary file formats used to read large amounts of data. Our > proprietary format performs very badly i.e. takes a long time to > load some > data; as expected

[sqlite] Database file size

2008-11-27 Thread Simon Bulman
Morning, I have been playing around with SQLite to use as an alternative to one of our proprietary file formats used to read large amounts of data. Our proprietary format performs very badly i.e. takes a long time to load some data; as expected SQLite is lighting quick in comparison - great!

Re: [sqlite] Syntax for sql 'insert' for text with comma

2008-11-27 Thread Martin.Engelschalk
Hi, text constants have to be set between single quotes: insert into sometable values ( 5 , 'text' ) If the text contains a single quote, double it: insert into sometable values ( 5 , 'Don''t do this' ) Martin Mauricio schrieb: > Hi, > > I would like to > > insert into sometable values (

[sqlite] Syntax for sql 'insert' for text with comma

2008-11-27 Thread Mauricio
Hi, I would like to insert into sometable values ( someid , text ) ; but 'text' contains a few commas, and then it would look like (...) values ( someid , text , text2 , text3 ) ; Is there a syntax to do that properly, maybe like C string constants ("text,\"text\",text\n")? Thanks, Maurício