D. Richard Hipp wrote:
>On May 28, 2008, at 11:24 AM, Robert Simpson wrote:
>
>
>
>>You can browse the SVN sources for Mono.Data.SQLite here: ...
>>
>>
>
>FWIW, I hereby make the following offer to any open-source projects
>related to SQLite:
>
> * A third-level domain name. Ex: m
On Thu, May 29, 2008 at 1:09 AM, <[EMAIL PROTECTED]> wrote:
> I've implemented this behaviour in my program. I was just curious whether
> it was possible in sql when I learnt about the Left Join (as there are more
> values in one column than the other).
>
> I guess it isn't or is not really the pr
Stephen Oberholtzer wrote:
>
> On Wed, May 28, 2008 at 11:15 PM, beejayzed <[EMAIL PROTECTED]> wrote:
>
>>
>> I have two tables, one which has each visit(call) on a house logged,
>> another
>> which has each letter sent to a house logged.
>> I would like to create a query which has two columns,
On Wed, May 28, 2008 at 11:15 PM, beejayzed <[EMAIL PROTECTED]> wrote:
>
> I have two tables, one which has each visit(call) on a house logged,
> another
> which has each letter sent to a house logged.
> I would like to create a query which has two columns, Letters.Date and
> Calls.Date, for a spe
"beejayzed" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> I have two tables, one which has each visit(call) on a house logged,
> another which has each letter sent to a house logged.
> I would like to create a query which has two columns, Letters.Date and
> Calls.Date, for a specifi
I have two tables, one which has each visit(call) on a house logged, another
which has each letter sent to a house logged.
I would like to create a query which has two columns, Letters.Date and
Calls.Date, for a specific HouseID.
I have tried this query for HouseID 16:
Select Letters.Date,Calls.D
I get this problem only after I stop a transaction in between which makes me
think that there is a problem with SQLite code.
Also, I forgot to mention that I am using SQLite version 3.0.8. Do you know
about any such bug in this version which was removed in the later versions?
Thanks & Regards
M
On May 28, 2008, at 7:04 PM, manas.abi wrote:
>
> I am using SQLite to maintain some transaction information but I see
> that if
> I stop the transaction in between then my database gets corrupted
> i.e. there
> is no Rollback from this point, hence there is only some data of the
> transactio
On May 28, 2008, at 7:21 PM, Samuel Neff wrote:
> It happens every time. I can send you a db and the update scripts,
> but I'll
> need you to keep it confidential (not signed affidavit or anything
> like
> that, just understanding that it's confidential).
>
> Please confirm this is ok and al
It happens every time. I can send you a db and the update scripts, but I'll
need you to keep it confidential (not signed affidavit or anything like
that, just understanding that it's confidential).
Please confirm this is ok and also which address I should send it to (if
other than the one you're
I am using SQLite to maintain some transaction information but I see that if
I stop the transaction in between then my database gets corrupted i.e. there
is no Rollback from this point, hence there is only some data of the
transaction which is written into the database. This means that SQLite is
n
On 5/28/08, Dennis Cote <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
>
> > It seems docs/compile.html is wrong.
> >
> > SQLITE_OMIT_DATETIME_FUNCS
> > If this option is defined, SQLite's built-in date and time manipulation
> > functions are omitted. Specifically, the SQL functions juli
Hello,
On May 27, 2008, at 9:47 PM, [EMAIL PROTECTED] wrote:
> Is this a limitation, or am I missing something?
Creating tables dynamically is not very useful in general, so perhaps
this is misguided, yes :)
On the other hand, an alternative I found useful is to use SQLite's
'attach databas
On Wed, May 28, 2008 at 1:31 PM, Dennis Cote <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> Another possibility would be to use the TIMESTAMP name for an integer
> unix epoch timestamp, and JULIANDAY for the floating point julian day
> number, giving five default value codes.
>
> Name
[EMAIL PROTECTED] wrote:
> It seems docs/compile.html is wrong.
>
> SQLITE_OMIT_DATETIME_FUNCS
> If this option is defined, SQLite's built-in date and time manipulation
> functions are omitted. Specifically, the SQL functions julianday(), date(),
> time(), datetime() and strftime() are not avail
Hello,
On May 27, 2008, at 9:07 PM, Stephen Oberholtzer wrote:
> Well, the first thing you should bring away from this experience is
> that the
> number of VM instructions isn't really an indicator of how efficient
> the
> query is :)
Good point :)
> Now, I'm not sure exactly why one is fas
Sqlite is a nicely structured C program which will always be better than
C++. Nice, clean easy to read and well documented C fits in everywhere.
Dennis Cote wrote:
> Rajesh Nair wrote:
>> Is there any program to develop sqlite in C++.
>
> See http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
Sweet. Thanks Robert. I anticipated your responses and I'm glad you're
still actively developing. I would have just emailed you directly, but
I was hoping for input from the mono team as well.
RW
Ron Wilson, S/W Systems Engineer III, Tyco Electronics, 434.455.6453
-Original Message-
F
It seems docs/compile.html is wrong.
SQLITE_OMIT_DATETIME_FUNCS
If this option is defined, SQLite's built-in date and time manipulation
functions are omitted. Specifically, the SQL functions julianday(), date(),
time(), datetime() and strftime() are not available. The default column
values CURR
[EMAIL PROTECTED] wrote:
> I am trying to create a table with a column with default value of current
> datetime (on insertion). But the following sql script can pass, but does not
> do what it is supposed to do.
>
> What is the correct syntax?
>
> create table ViewState
> (
> session_id text n
Rajesh Nair wrote:
> Is there any program to develop sqlite in C++.
See http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers for a selection
of C++ wrappers.
I would suggest trying CppSQlite since it is a thin wrapper with source
available for free.
> I have developed a C++ wrapper for sqlite3.
On 5/28/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I am trying to create a table with a column with default value of current
> datetime (on insertion). But the following sql script can pass, but does not
> do what it is supposed to do.
>
> What is the correct syntax?
>
> create table Vi
I am trying to create a table with a column with default value of current
datetime (on insertion). But the following sql script can pass, but does not do
what it is supposed to do.
What is the correct syntax?
create table ViewState
(
session_id text not null,
viewstate_key text not null,
vie
Is there any program to develop sqlite in C++.
I have developed a C++ wrapper for sqlite3.x but if sqlite3 itself is
developed in C++ then it could be more readable.
I know C, but not a hardcore C programmer.And is working with VC++ for
last 6 years (MFC and ATL) .
- Original Message --
On May 28, 2008, at 11:24 AM, Robert Simpson wrote:
> You can browse the SVN sources for Mono.Data.SQLite here: ...
FWIW, I hereby make the following offer to any open-source projects
related to SQLite:
* A third-level domain name. Ex: mono.sqlite.org
* Your own website. Ex:
On May 28, 2008, at 11:25 AM, Jens Miltner wrote:
> s there any work being done trying to either minimize the
> synchronization needed or provide a memory allocator that doesn't do
> all the alerting
Yes. This has been requested before and will appear soon.
D. Richard Hipp
[EMAIL PROTECTED]
I'd like to chime in that we have somewhat similar requirements:
Our app is heavily threaded and we had sqlite's memory allocations
show up as bottlenecks at times. This happened when the 'new'
allocators that allow for high-water marks, etc. appeared first. Since
we don't need any of the hig
1. "Better" is a relative term. Since the effort of porting changes from
my version to mono is non-trivial, I imagine that mono will be slower to
adapt to newer SQLite releases in favor of stabilizing the port. So you
might get a more stable, less frequently updated version from Mono.
2. Ties i
What if you took a slightly different tack?
CREATE TABLE FinishedWork (
EventTime INTEGER NOT NULL,
FileName TEXT NOT NULL,
ProcessID INTEGER NOT NULL,
BytesProcessed INTEGER NOT NULL,
isDuplicate integer-- tri-state: 0=not duplicate 1=duplicate
null=unknown
);
And then periodically run this
On Wed, May 28, 2008 at 12:32 AM, sqlite <[EMAIL PROTECTED]>
wrote:
>
> Dear Stephen,
>
> Thanks for the reply. As you said we checked the EXPLAIN QUERY PLAN with
> our
> query and it has shown that all the four tables we use in the query are
> using their indexes and there is no ORDER BY class in
Thank you for your help- I understand it better and can work it out now.
--
View this message in context:
http://www.nabble.com/Possible-to-use-field-names-instead-of-index-offsets-in-queries--tp17461475p17511500.html
Sent from the SQLite mailing list archive at Nabble.com.
___
"sqlite" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> Thanks for your reply, we already tried this method but by executing
> the sqlite_reset function it will again prepare the rowset, which
> takes more time for us to get the initial record, is there any other
> way to get the ini
Igor Tandetnik wrote:
>
> "sqlite" <[EMAIL PROTECTED]> wrote
> in message news:[EMAIL PROTECTED]
>> We are using SQLite for our application development which would be
>> deployed in a pocket pc.Here we are using a query which has three
>> Inner joins and using sqlite3_prepare and sqilte3_step fu
"sqlite" <[EMAIL PROTECTED]> wrote
in message news:[EMAIL PROTECTED]
> We are using SQLite for our application development which would be
> deployed in a pocket pc.Here we are using a query which has three
> Inner joins and using sqlite3_prepare and sqilte3_step function to
> prepare the records an
Dear All,
We are using SQLite for our application development which would be deployed
in a pocket pc.Here we are using a query which has three Inner joins and
using sqlite3_prepare and sqilte3_step function to prepare the records and
to fetch the records.By executeing the Query and we moves to c
35 matches
Mail list logo