Fred Williams wrote:
-Original Message-
From: Michael Roth [mailto:[EMAIL PROTECTED]
Sent: Thursday, May 20, 2004 9:10 AM
To: Ulrik Petersen
Cc: [EMAIL PROTECTED]
Subject: Re: [sqlite] Newbie --question about multiple PCs accessing
sqlite
Ulrik Petersen wrote:
- Mingw or Cygwin (google fo
hi, sir
I'd like to port sqlite to my S3C4510 board, and the embOS is uClinux. I don't know
how can i start. If anybody can make some suggestions, i will be lucky to be here.
Jeanwelly
-
To unsubscribe, e-mail: [EMAIL PR
> Any Ideas what could be going wrong here.
Hint: '1' is not equal to ' 1'
Regards
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
sqlite> select statustext from statustext, spmblock where spmblock.spmstatus
= statustext.statusid;
sqlite> .schema statustext
CREATE TABLE [StatusText] (
[StatusId] char(4) NOT NULL ,
[StatusText] [nvarchar] (50) NOT NULL
);
sqlite> .schema spmblock
CREATE TABLE SPMBlock (
> > CREATE TABLE [SPMBlock] (
> > [SPMId] [int] identity(1,1) NOT NULL ,
Does "identity" do the same thing as it does under MS SQL Server? I thought
the way to get an identity field in SQLite was to define it as "integer
primary key".
---
"Rao, Prasanna [EPM/RTC]" <[EMAIL PROTECTED]> writes:
> --Drop table SPMBLOCK;
>
> CREATE TABLE [SPMBlock] (
> [SPMId] [int] identity(1,1) NOT NULL ,
>[DeviceId] char (3) ,
>[SPMIndex] char (3) ,
>[SPMStatus] char (4) ,
>[BaselineMean] char (10) DE
I think version 3.x should do sorting and grouping on disk. Using temporary
tables?
Once we have btrees, why not using them?
It may not be the fastest way of doing it, but it saves lots of memory.
Perhaps it could begin doing it in memory and when reaching some certain
value it could use the extern
--Drop table SPMBLOCK;
CREATE TABLE [SPMBlock] (
[SPMId] [int] identity(1,1) NOT NULL ,
[DeviceId] char (3) ,
[SPMIndex] char (3) ,
[SPMStatus] char (4) ,
[BaselineMean] char (10) DEFAULT (0),
[Mean] char (10) DEFAULT (0),
On Wed, 19 May 2004, Stefano Barbato wrote:
>Hi,
>
>I already tried to find the aswer on the faq/wiki/mailing list archive/google
>with no luck so here is my question:
>
>is there a way to detect at runtime if the sqlite library has been compiled
>with the THREADSAFE=1 flag or not?
>
>I need threa
> -Original Message-
> From: Michael Roth [mailto:[EMAIL PROTECTED]
> Sent: Thursday, May 20, 2004 9:10 AM
> To: Ulrik Petersen
> Cc: [EMAIL PROTECTED]
> Subject: Re: [sqlite] Newbie --question about multiple PCs accessing
> sqlite
>
>
> Ulrik Petersen wrote:
>
> > - Mingw or Cygwin (goog
Ulrik Petersen wrote:
- Mingw or Cygwin (google for each)
www.mingw.org, www.cygwin.com
- Microsoft Visual C++ Toolkit 2003. Microsoft recently released their
compiler and toolchain for free download:
http://msdn.microsoft.com/visualc/vctoolkit2003/
Check the license! It is not really fair! Don't
Hello Shamil,
[EMAIL PROTECTED] wrote:
I do not have a C++ compiler
If you are using Linux or some other Unix-like environment, you can get
g++ (i.e., gcc) for free.
If you are using Windows, there are several options for getting one
(also for free):
- Mingw or Cygwin (google for each)
- Mic
On Thursday 20 May 2004 09:31, Stefano Barbato wrote:
> On Thursday 20 May 2004 00:25, Peter wrote:
> > Stefano Barbato wrote:
> > > is there a way to detect at runtime if the sqlite library has been
> > > compiled with the THREADSAFE=1 flag or not?
> >
> > No, or not that I know of. It would be ni
On Thursday 20 May 2004 00:25, Peter wrote:
> Stefano Barbato wrote:
> > is there a way to detect at runtime if the sqlite library has been
> > compiled with the THREADSAFE=1 flag or not?
>
> No, or not that I know of. It would be nice for ver 3 to have a simple
> function which returns a structure
14 matches
Mail list logo
