Looks reasonable. Consider filing a ticket with your patch.
A few "make test" tests that rely on the old short name behavior
for SELECT * with joins will report failure. Whether the old way is
necessarily correct in some tests is a matter of debate.
--- Sandeep Suresh <[EMAIL PROTECTED]>
Thanks Vitali, and Trevor. I'll poke them instead ;)
> Firefox is now using sqlite. They use shared-cache mode because they want it
> to work over networked drives and they don't want to pay for the
> latency involved.
The "shared cache mode" in sqlite only changes certain behavior for
threads
On 12/6/06, Jay Sprenkle <[EMAIL PROTECTED]> wrote:
Firefox is now using sqlite. They use shared-cache mode because they want it
to work over networked drives and they don't want to pay for the
latency involved.
The "shared cache mode" in sqlite only changes certain behavior for
threads in
http://www.sqlite.org/sharedcache.html
It's controlled at runtime by the function
int sqlite3_enable_shared_cache(int);
Thus that behaviour is probably controlled by Firefox (assuming it uses a
version of sqlite with cache support compiled in). You'd have to ask them.
Jay Sprenkle wrote:
Good evening,
I'd like to make a request for the next version of sqlite.
It's a big change and will probably get shot down, but you won't know
until you ask.
Firefox is now using sqlite. They use shared-cache mode because they want it
to work over networked drives and they don't want to pay for
Buzz,
Access questions should be directed to Microsoft.
http://office.microsoft.com/access/
On 12/6/06, Buzz Hill <[EMAIL PROTECTED]> wrote:
Hi,
I am trying to pull records from a Microsoft Access db using ODBC.
The connection works fine. I can get results when I test for any field with an
Hi,
I am trying to pull records from a Microsoft Access db using ODBC.
The connection works fine. I can get results when I test for any field with an
integer value.
The problem I am having is with dates. Something as simple as:
SELECT * FROM CostingHeader where DeliveryDate = '2/6/2004'
or
thank you all,all your ideas are good.btw,Stanton's logic transaction is a
little hard to understand,can you show me a link where I can read the
detail.
2006/12/7, Nicolas Williams <[EMAIL PROTECTED]>:
On Wed, Dec 06, 2006 at 12:51:29PM -0600, John Stanton wrote:
> To fully handle the
Unfortunately it looks it needs installing the .NET framework and J#.
I will keep it in mind, but for now that has put me off this route.
RBS
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 06 December 2006 23:16
To: sqlite-users@sqlite.org
Subject: Re: [sqlite]
Thanks, I had found it.
RBS
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 06 December 2006 23:43
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Interbase to SQLite
RB Smissaert wrote:
> Thanks for the tip. It sounds promising and I will try that out.
>
>
RB Smissaert wrote:
Thanks for the tip. It sounds promising and I will try that out.
Oops. I forgot to add the link
http://www.borland.com/us/products/turbo/index.html to speedup locating it.
Good Luck.
Dennis Cote
Thanks for the tip. It sounds promising and I will try that out.
RBS
-Original Message-
From: Dennis Cote [mailto:[EMAIL PROTECTED]
Sent: 06 December 2006 23:16
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Interbase to SQLite
RB Smissaert wrote:
> I think I might have asked this
RB Smissaert wrote:
I think I might have asked this before, but I still haven't figured it out.
What would be the fastest way to move data from Interbase to SQLite?
I will have to do this in VB/VBA, unless I could use a dll written in for
example C or C++.
Currently I get the data with the
On Wed, Dec 06, 2006 at 12:51:29PM -0600, John Stanton wrote:
> To fully handle the situation you need to know how many users have a
> transaction pending and are pondering ordering the item. That requires
> some form of journal or "committed" total. If you have three items and
> there are
This is the patch to fix the problem I mentioned below. Can someone take
a look and see if this is a right fix ? It seems to be working fine in
a few tests that I did.
Index: select.c
===
RCS file:
I think I might have asked this before, but I still haven't figured it out.
What would be the fastest way to move data from Interbase to SQLite?
I will have to do this in VB/VBA, unless I could use a dll written in for
example C or C++.
Currently I get the data with the Intersolve ODBC driver,
Nicolas Williams wrote:
On Wed, Dec 06, 2006 at 11:36:11AM -0600, John Stanton wrote:
I fully understood. It is an age old problem that has puzzled
generations of system designers. My first exposure was over thirty
years ago. The approach we discovered worked was to treat it as a
On Wed, Dec 06, 2006 at 11:36:11AM -0600, John Stanton wrote:
> I fully understood. It is an age old problem that has puzzled
> generations of system designers. My first exposure was over thirty
> years ago. The approach we discovered worked was to treat it as a
> transaction in the logical
Nicolas Williams wrote:
On Wed, Dec 06, 2006 at 10:06:12AM -0600, John Stanton wrote:
Marten Feldtmann wrote:
But Tcl is not part of SQLite (and this is good) - this is just an
add-on. The idea with the
additional functions are pretty good !
How does Sqlite become Sqbloated? By function
Nicolas Williams wrote:
On Wed, Dec 06, 2006 at 10:04:42AM -0600, John Stanton wrote:
hongdong wrote:
I just have a base question:
assume user A and user B now both connection to a same database and both of
them want to update a same record,but only one is allowed
in this condition:
A
On Wed, Dec 06, 2006 at 10:06:12AM -0600, John Stanton wrote:
> Marten Feldtmann wrote:
> >But Tcl is not part of SQLite (and this is good) - this is just an
> >add-on. The idea with the
> >additional functions are pretty good !
> >
> How does Sqlite become Sqbloated? By function creep, one
On Wed, Dec 06, 2006 at 10:04:42AM -0600, John Stanton wrote:
> hongdong wrote:
> >I just have a base question:
> >assume user A and user B now both connection to a same database and both of
> >them want to update a same record,but only one is allowed
> >in this condition:
> >A begin to browse
Marten Feldtmann wrote:
Ulrich Schöbel schrieb:
SQLite includes a Tcl API. Tcl does all these conversions with ease.
See the encoding convertto/convertfrom commands and fconfigure
But Tcl is not part of SQLite (and this is good) - this is just an
add-on. The idea with the
additional
hongdong wrote:
I just have a base question:
assume user A and user B now both connection to a same database and both of
them want to update a same record,but only one is allowed
in this condition:
A begin to browse the data in a client application,and load rowid into GUI
and keep it in
-Original Message-
From: Nikki Locke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, December 06, 2006 6:06 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] a question about muticonnection
Hongdong wrote:
> I just have a base question:
> assume user A and user B now both connection to
Thanks a lot,Nikki's solution is what I think about,but this may lost some
efficiency,maybe this is the only way.
Mario's solution is more easy,but there something hard to control,somebody
will just open the window,displaying the data,but he will never modify the
data,that will resist other
Pusedo code:
set s.sql = 'select a from mytable where (b=0)';
if got.more then
set s.sql = s.sql + ' and ' + s.userinput;
...
set s.sql = s.sql + ';';
> -Original Message-
> From: Lloyd [mailto:[EMAIL PROTECTED]
> Sent: Thursday, December 07, 2006 2:46 AM
> To: sqlite-users@sqlite.org
hongdong wrote:
I just have a base question:
assume user A and user B now both connection to a same database and
both of
them want to update a same record,but only one is allowed
in this condition:
A begin to browse the data in a client application,and load rowid into
GUI
and keep it in
Hongdong wrote:
> I just have a base question:
> assume user A and user B now both connection to a same database and both of
> them want to update a same record,but only one is allowed
> in this condition:
> A begin to browse the data in a client application,and load rowid into GUI
> and
At 2:15 PM +0530 12/7/06, Lloyd wrote:
Hi,
I am generating queries dynamically from my program based on the input.
The primary part of the query is always
select a from mytable where (b=0) and
based on the user input I add more where clauses to my query like
select a from mytable where (b=0)
Thanks, 0=0 works well enough for me. (This hint is what I wanted)
Thanks again,
Lloyd
On Wed, 2006-12-06 at 10:00 +0100, Mario Frasca wrote:
> Lloyd wrote:
>
> >select a from mytable where (b=0) and
> >
> >and this is a syntax error.
> >
> >
> you're not saying which language you're using.
Lloyd wrote:
select a from mytable where (b=0) and
and this is a syntax error.
you're not saying which language you're using.
in Python a common solution looks like this:
clauses = []
# add strings to the clauses list, like
clauses.append('(b=0)')
# join the parts using appropriate glue
Ulrich Schöbel schrieb:
SQLite includes a Tcl API. Tcl does all these conversions with ease.
See the encoding convertto/convertfrom commands and fconfigure
But Tcl is not part of SQLite (and this is good) - this is just an
add-on. The idea with the
additional functions are pretty good !
Hi,
I am generating queries dynamically from my program based on the input.
The primary part of the query is always
select a from mytable where (b=0) and
based on the user input I add more where clauses to my query like
select a from mytable where (b=0) and (x=10)
but in one case there in no
I just have a base question:
assume user A and user B now both connection to a same database and both of
them want to update a same record,but only one is allowed
in this condition:
A begin to browse the data in a client application,and load rowid into GUI
and keep it in memory.
B update the
35 matches
Mail list logo
