"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 =
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
> 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
-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)
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,
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
-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.
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
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
> 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
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
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
>
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
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!
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 (
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
16 matches
Mail list logo