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
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
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
"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
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
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
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
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
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
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
[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
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
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.
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
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
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
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
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
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
"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
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
25 matches
Mail list logo