Monday, April 21, 2008, 10:44:15 AM, you wrote:
>> I actually need to call a function for each iteration of
>> sqlite3_step() and depending on what it returns, delete the row or
>> not.
B> Perhaps you could include your function in an example.
Well it is a function that calls various other fun
> I actually need to call a function for each iteration of
> sqlite3_step() and depending on what it returns, delete the row or
> not.
Perhaps you could include your function in an example.
Tom
BareFeet
http://www.tandb.com.au/sqlite/compare/?ml
__
Hi Tom,
Monday, April 21, 2008, 10:05:04 AM, you wrote:
B> Hi Neville,
>> Use the latest SQLite Version can you do:
>>
>> select clma from tablea;
>> while( sqlite3_step() )
>> {
>>if ( clma == somevalue )
>> delete from tablea clma=somevalue;
>>else
>> process row;
>> }
>
Hi James,
> I tried to do a
> "SELECT TOP 10 * FROM tab1" and sqlite3 complained.
Is this what you're after?:
select * from tab1 limit 10;
Tom
BareFeet
http://www.tandb.com.au/sqlite/compare/?ml
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hi Neville,
> Use the latest SQLite Version can you do:
>
> select clma from tablea;
> while( sqlite3_step() )
> {
>if ( clma == somevalue )
> delete from tablea clma=somevalue;
>else
> process row;
> }
>
> ie. Delete a row while stepping through the results of a select and
I implemented a DECIMAL type and ended up making a small patch to Sqlite
to stop it changing the type to numeric. As I recall it was very simple.
Aladdin Lampé wrote:
> Hi!
> I've just created my own "DECIMAL" set of user functions using the IBM
> decNumber library.
> I would like to assign my
On Sun, Apr 20, 2008 at 09:29:34AM -0600, Dennis Cote scratched on the wall:
> Jay A. Kreibich wrote:
> >
> > It breaks for everything except network_size == 16.
> >
> Why do you say that?
> > You want something closer to (ip_addr & (~(~0 << network_size)))
> >
> In SQLite ~0 is -1.
>
>s
On Sun, Apr 20, 2008 at 5:07 PM, James Dodd <[EMAIL PROTECTED]> wrote:
> Hi,
>
> (Newbie to sqlite, some experience with SQL Server 2000). I tried to do a
> "SELECT TOP 10 * FROM tab1" and sqlite3 complained. Then I looked at the SQL
> syntax page and indeed TOP doesn't seem to be there. Is ther
Hi,
(Newbie to sqlite, some experience with SQL Server 2000). I tried to do a
"SELECT TOP 10 * FROM tab1" and sqlite3 complained. Then I looked at the SQL
syntax page and indeed TOP doesn't seem to be there. Is there a reason for
this and, better still, is there a way to get around it? Or is it t
Hi!
I've just created my own "DECIMAL" set of user functions using the IBM
decNumber library.
I would like to assign my decimal columns the type "DECIMAL([precision])", but
they are given the NUMERIC affinity, and numbers are converted when inserted in
TEXT format... That's exactly what I'm try
Use the latest SQLite Version can you do:
select clma from tablea;
while( sqlite3_step() )
{
if ( clma == somevalue )
delete from tablea clma=somevalue;
else
process row;
}
ie. Delete a row while stepping through the results of a select and
know the remaining sqlite3_
* Jay A. Kreibich:
>> Is this Java or C? For C, this breaks if network_size == 32.
>
> It breaks for everything except network_size == 16.
I was alluding to the fact that a popular architecture implements
modulo-32 shifts for 32-bit integers (and modulo-64 shifts for 64-bit
integers), for exam
I'm trying to figure out how to insert and retrieve a NAN value from
an sqlite database. I'm on Mac OS X 10.5 which is using sqlite3 3.4.0.
Obviously, using the sqlite3 command line tool, this is what I get:
$ sqlite3 nantest.db
SQLite version 3.4.0
Enter ".help" for instructions
sqlite> CREATE
P Kishor,
> I have no idea how I conveyed that impression. I think FTS3 is really
> wonderful, and have implemented it in my own personal website. I firmly
> believe in the "Why file when you can full-text search" doctrine.
Excellent! Thanks for the follow-up. You answered my questions. And put
On 4/20/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> >> Is SQLite's full text ready for production use yet?
>
> > as ready as it will be. FTS 1/2 are deprecated.
>
>
> You don't sound too thrilled :) Are there any limitations that one
> should be aware of?
I have no idea how I conveyed th
>> Is SQLite's full text ready for production use yet?
> as ready as it will be. FTS 1/2 are deprecated.
You don't sound too thrilled :) Are there any limitations that one
should be aware of?
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-u
On 4/20/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I'm trying to figure out the status of SQLite's support for full-text
> search.
>
> It appears that full-text support was provisionally added to SQLite in
> late 2006 via an extension module. It sounds like this early version was
> expe
I'm trying to figure out the status of SQLite's support for full-text
search.
It appears that full-text support was provisionally added to SQLite in
late 2006 via an extension module. It sounds like this early version was
experimental only.
After more googling it appears that there are two add-on
yes. However, CoreData queues up modified managed objects in a managed
object context and then commits them all in one shot making sure the
serialization is done on the back side.
So, it does basically what someone here recommended earlier. I just
don't have to write the mechanism myself.
I'm sorry if this reply seems jumbled - I wrote the middle bit (about
the sugested content) after the bits above and below it.
Jay A. Kreibich wrote:
> On Sat, Apr 19, 2008 at 05:40:45PM +0100, Toby Roworth scratched on the wall:
>
>> mikeobe wrote:
>>
>>> i found it boring to learn how t
James Gregurich wrote:
> I think I will go with CoreData on MacOSX and figure out something
> else to do on Windows later.
>
>
>
You do know that CoreData uses SQLite for its persistant storage.
Dennis Cote
___
sqlite-users mailing list
sqlite-users
Jay A. Kreibich wrote:
>
> It breaks for everything except network_size == 16.
>
Why do you say that?
> You want something closer to (ip_addr & (~(~0 << network_size)))
>
In SQLite ~0 is -1.
sqlite> select ~0;
-1
So your inner expression is only a more complicated way of saying
Florian Weimer wrote:
>
> Is this Java or C? For C, this breaks if network_size == 32.
>
It is SQL (with SQLite extensions which are modeled after C). SQLite
has a 64 bit integer type so the bit shifting works as expected for all
values up to 63. The same logic can be used in other language
Jay A. Kreibich wrote:
> On Sun, Apr 20, 2008 at 11:13:56AM +0200, Florian Weimer scratched on the
> wall:
>
>>* Dennis Cote:
>>
>>
>>>This last function can be implemented using bit manipulation operators
>>>in SQL or in a custom function in C.
>>>
>>>containedIn(ip_addr, network_addr, netw
On Sun, Apr 20, 2008 at 11:13:56AM +0200, Florian Weimer scratched on the wall:
> * Dennis Cote:
>
> > This last function can be implemented using bit manipulation operators
> > in SQL or in a custom function in C.
> >
> > containedIn(ip_addr, network_addr, network_size)
> >
> > can be replac
It works now, thanks!
P.P.
> From: [EMAIL PROTECTED]
> To: sqlite-users@sqlite.org
> Date: Sat, 19 Apr 2008 08:43:42 -0400
> Subject: Re: [sqlite] EXISTS operator doesn't seem to work
>
>
> On Apr 19, 2008, at 7:06 AM, pinco palletto wrote:
>
> > update register
> > set note = (select ORT.no
* Dennis Cote:
> This last function can be implemented using bit manipulation operators
> in SQL or in a custom function in C.
>
> containedIn(ip_addr, network_addr, network_size)
>
> can be replaced by
>
> nework_addr == (ip_addr & (-1 << network_size))
>
> which will be true if the IP a
On Apr 20, 2008, at 12:29 AM, James Gregurich wrote:
>
> oh good! That isn't the version that ships with Leopard, but I can
> live with deploying my own version as part of my app.
>
> Will l get the writer parallelism I'm after as long as each thread
> writes exclusively into its own attached db?
Hi,
> NO make file found in that zip, downloaded from the official website...
Which exact ZIP file?
--
Dimitri
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
29 matches
Mail list logo