Brown, Daniel <[EMAIL PROTECTED]> wrote:
> Does SQLite support/implement cursors of any form
sqlite3_step is, in some sense, a forward-only cursor.
You might also find this interesting:
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
Igor Tandetnik
__
Good Evening list,
Does SQLite support/implement cursors of any form, I've been searching
through the documentation about this but I suspect either cursor is the
wrong term for SQLite or they are either not supported or implemented.
Could anyone clear this up for me?
Cheers,
Daniel Brown
"The b
Hello,
Le 22 juil. 08 à 20:17, Alexey Pechnikov a écrit :
>
> Hello!
>
> Can I found functions for ip address/mask operations?
>
> Best regards, Alexey.
I am a new user, and was looking for ip network/mask function too.
I found none, so I just wrote an extension (tested on linux and
MacOSX 10.5,
On Tue, Jul 22, 2008 14:24:38 PM -0400, Igor Tandetnik wrote:
> Are you familiar with SQLite full-text search (FTS) extension?
No, thanks for the link, will study it.
> > - calculation of moving average of a floating field, eg if a table is
...
> Any solution in pure SQL is going to be awkward.
M. Fioretti <[EMAIL PROTECTED]> wrote:
> A few examples of the kind of queries I'd
> like to (learn how to) optimize first:
>
> - search of strings in text fields (both sub-words and whole words)
Are you familiar with SQLite full-text search (FTS) extension?
http://www.sqlite.org/cvstrac/wiki?p=F
Igor Tandetnik wrote:
> Giuseppe Costanzi <[EMAIL PROTECTED]> wrote:
>
>> How extract the month and/or year from a datetime field?
>> For example:
>>
>> SELECT OrderID,OrderDate
>> FROM tblOrders
>>
>
> select OrderID, strftime('%m', OrderDate) as Month, strftime('%Y',
> OrderDate) as Yea
Hello!
Can I found functions for ip address/mask operations?
Best regards, Alexey.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Giuseppe Costanzi <[EMAIL PROTECTED]> wrote:
> How extract the month and/or year from a datetime field?
> For example:
>
> SELECT OrderID,OrderDate
> FROM tblOrders
select OrderID, strftime('%m', OrderDate) as Month, strftime('%Y',
OrderDate) as Year
from tblOrders;
http://sqlite.org/lang_datef
Again, you've given a relatively broad description of what you're
trying to do. I could make up a bunch of stuff and answer my own
question, but you'd probably rather than I considered the problem
_you_ are having. It sounds like you've actually committed code to do
this - post the SQL CREATE sta
Hi,
How extract the month and/or year from a datetime field?
For example:
SELECT OrderID,OrderDate
FROM tblOrders
OrderDate is in datetime format and I would extract
grouping for months
regards
Giuseppe
___
sqlite-users mailing list
sqlite-users@sql
Greetings,
I am looking for tips, tricks and general information, both for
personal usage (I'd like to move as many as possible of my
SOHO-related databases to SQLITE) and for an online article, about
SQLite3 query optimization tricks. I have already found and will study
these pages:
http://www.s
On Tue, 22 Jul 2008, Keith Goodman wrote:
> On Tue, Jul 22, 2008 at 7:27 AM, Milton Centeno <[EMAIL PROTECTED]> wrote:
>> Thank you for your response.
>>
>> at the sqlite> prompt I enter sqlite3 test.db then I get ...>
>> entering .databases gives me another ...>
>> If I hit the Ctrl C it exits a
On 7/22/08, Steve Friedman <[EMAIL PROTECTED]> wrote:
>
>
>
> Actually, I have both --enable-tempstore=always and -DTEMP_STORE=2
> (belts and suspenders).
Then you probably want to use -DSQLITE_TEMP_STORE=2 instead.
___
sqlite-users mailing list
sqlite-
yeah, if you just enter sqlite3 then it creates an in-memory database,
to create a working and existing database, enter "sqlite3 test.db" at
the C:\ prompt. Example "C:\> sqlite3 test.db"
Ignore my comment on the Ctrl + C, if you're seeing the ---> then it's
waiting for a semi-colon ";".
Thanks
>
Shane Harrelson wrote:
> I checked in some updates to the "configure" support that will hopefully do
> the right thing and pass any OMIT options to lemon and mkkeywordhash.
Thanks, this allowed the code to compile to completion, leaving only 3
minor warnings:
sqlite3.c: In function ‘rtreeCreate
On Tue, Jul 22, 2008 at 7:27 AM, Milton Centeno <[EMAIL PROTECTED]> wrote:
> Thank you for your response.
>
> at the sqlite> prompt I enter sqlite3 test.db then I get ...>
> entering .databases gives me another ...>
> If I hit the Ctrl C it exits and closes the prompt window.
The command 'sqlite3
Thank you for your response.
at the sqlite> prompt I enter sqlite3 test.db then I get ...>
entering .databases gives me another ...>
If I hit the Ctrl C it exits and closes the prompt window.
On 7/22/08, Greg Morphis <[EMAIL PROTECTED]> wrote:
>
> sqlite3 test.db works, what error are you gett
Milton Centeno wrote:
>
> I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed
> in the getting started guide on the website do not appear to work for me.
> What are the commands to simply create a database in sqlite and how to exit
> when in the ">" prompt? Thank you.
Hi, Milton,
Regarding: The command "sqlite3 test.db" and "sqlite3 ex1"
You're referring the to command line test program, "sqlite3" or
"sqlite3.exe".
These commands will create databases named "test.db" and "ex1"
respectively, if they did not exist before you ran the command. Of
course, t
2008/7/22 Milton Centeno <[EMAIL PROTECTED]>:
> Hi,
>
> I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed
> in the getting started guide on the website do not appear to work for me.
> What are the commands to simply create a database in sqlite and how to exit
> when in th
sqlite3 test.db works, what error are you getting?
and to exit (on a windows system Ctrl + C works
On Tue, Jul 22, 2008 at 9:01 AM, Milton Centeno <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed
> in the getting started guide on the
Hi,
I'm new to sqlite. The command "sqlite3 test.db" and "sqlite3 ex1" as listed
in the getting started guide on the website do not appear to work for me.
What are the commands to simply create a database in sqlite and how to exit
when in the ">" prompt? Thank you.
respectfully,
Milton
__
> It's hard to say - you might want to describe your tables and the join
> by simply including the SQL itself, rather than a loose description of
> it. It may be that there's a simple change which will clear things
> up.
Ok, what exactly I mean is a table containing tracks in an audio library,
i.
"Jawahar Nayak" <[EMAIL PROTECTED]>
wrote in message
news:[EMAIL PROTECTED]
>I am sqllite user. I am using sqlite3-3.5.9. I am inserting some
> unicode data in utf-8 encoding format in database. When I tried the
> data back from the database it seems that data is being converted to
> some other
Hi,
I am sqllite user. I am using sqlite3-3.5.9. I am inserting some unicode
data in utf-8 encoding format in database. When I tried the data back from
the database it seems that data is being converted to some other encoding.
Conversion may take place at insertion time. I am not sure. Is there
2008/7/22 Joanne Pham <[EMAIL PROTECTED]>:
> Hi All,
> I am current using sqlite 3.5.9 and below is command to get the data from my
> database as:
> .output '/opt/phoenix/monitor/exportData'
> .mode csv
> select '#Monitored applications' , group_concat(appName) from appMapTable;
> The
26 matches
Mail list logo