On 02/10/2012 11:06 PM, Ralf Junker wrote:
On 07.02.2012 12:28, Ralf Junker wrote:
The new feature to insert multiple rows of VALUES in a single INSERT
http://www.sqlite.org/src/info/eb3b6a0ceb
gives wrong results if SQLite is compiled with SQLITE_OMIT_COMPOUND_SELECT.
Has the team seen
HI Friends,
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.
Can any one tell me how to check if table in a data base is empty
or not, using sqlite3.
Regards,
Bhaskar.
--
View this message in context:
Hello,
I am wondering if there is there a place that collect all available sqlite
extensions.
Please let me know.
Thanks.
--
Marco Bambini
http://www.sqlabs.com
http://twitter.com/sqlabs
___
sqlite-users mailing list
sqlite-users@sqlite.org
bhaskarReddy wrote:
>How to check whether a table is empty or not. If a table is empty, i
> want to do some logic. If not another logic.
select exists (select 1 from MyTable);
--
Igor Tandetnik
___
sqlite-users mailing list
On 13.02.2012 10:18, Dan Kennedy wrote:
> On 02/10/2012 11:06 PM, Ralf Junker wrote:
>>
>>> The new feature to insert multiple rows of VALUES in a single INSERT
>>>
>>>http://www.sqlite.org/src/info/eb3b6a0ceb
>>>
>>> gives wrong results if SQLite is compiled with
>>>
Hello
Is it possible to have a context for a custom SQL function that is NOT
an aggregate function? It might sound silly, but if a SELECT
statement with this function causes the function to be called in a
defined order (as with the step function of an aggregate function),
this can be useful to
You can't call sqlite3_aggregate_context() in a non-aggregate function.
However, there *are* a couple of other things you can do.
(1) All forms of sqlite3_create_function() take as 5th argument a void
pointer to an arbitrary user data structure. This data structure can be
accessed in a
On 13 Feb 2012, at 1:02pm, Igor Tandetnik wrote:
> bhaskarReddy wrote:
>> How to check whether a table is empty or not. If a table is empty, i
>> want to do some logic. If not another logic.
>
> select exists (select 1 from MyTable);
Or
SELECT COUNT(*) from MyTable
Regarding:
My question is, when I insert new data, is the needed space allocated out
> of the free_list or do the db file grows larger and the free space stays
> till vacuum operation is performed?
> Basically, my question is: on intensive inserts and deletes will the freed
> space be re-used ?
>
All,
How can I call the pragma statements, more specifically the PRAGMA
FOREIGN_KEYS=ON from within the Tcl environment?
Thanks,
Jerry
Disclaimer
This email is confidential and intended solely for the use of the individual to
whom it is addressed. Any
On Mon, Feb 13, 2012 at 03:48:24PM +, Simon Slavin scratched on the wall:
>
> On 13 Feb 2012, at 1:02pm, Igor Tandetnik wrote:
>
> > bhaskarReddy wrote:
> >> How to check whether a table is empty or not. If a table is empty, i
> >> want to do some logic. If not
2012/2/13 Igor Tandetnik :
> bhaskarReddy wrote:
>> How to check whether a table is empty or not. If a table is empty, i
>> want to do some logic. If not another logic.
>
> select exists (select 1 from MyTable);
SELECT exists(SELECT 1 FROM MyTable
On 13 Feb 2012, at 4:05pm, Tilsley, Jerry M. wrote:
> How can I call the pragma statements, more specifically the PRAGMA
> FOREIGN_KEYS=ON from within the Tcl environment?
Execute them the same way you'd execute a 'SELECT' SQL command.
Simon.
___
On 2/13/2012 11:20 AM, Kit wrote:
2012/2/13 Igor Tandetnik:
bhaskarReddy wrote:
How to check whether a table is empty or not. If a table is empty, i
want to do some logic. If not another logic.
select exists (select 1 from MyTable);
SELECT
[Peter Aronson]
> (2) You can associate data with an argument to a regular user-defined
> function using sqlite3_set_auxdata() and sqlite3_get_auxdata() as long
> as the value of the argument is static. If you don't normally have a
> static argument to your function, you can add one (say a
I believe It's private to that query as it is stored in sqlite3_context
structure at the moment (the context being stored in a stack variable during
SQL
execution as far as I can tell). I'd assume this is stable behavior, but you'd
have to ask the SQLite Dev team for an official answer. I
On Mon, Feb 13, 2012 at 9:24 AM, Steinar Midtskogen
wrote:
> [Peter Aronson]
>> (2) You can associate data with an argument to a regular user-defined
>> function using sqlite3_set_auxdata() and sqlite3_get_auxdata() as long
>> as the value of the argument is static. If you
Hello Dan,
thank you for the response, that did it.
Unfortunately, this 'breaks' the fts_table_terms functionality in the sense
that real terms (e.g. with diacritics) cannot be retrieved using that
table, since they're stored without.
I wanted to use that table for autocomplete feature in a text
[Scott Hess]
> I think you're making unwarranted assumptions about the order your
> custom function will be called. Even if you added "ORDER BY" to the
> end of the query, that wouldn't necessarily order the calls to your
> custom function. Even if you find a workaround which allows you to
>
On 13 Feb 2012, at 7:51pm, Steinar Midtskogen wrote:
> One should think that the ability to calculate a moving average would
> be a pretty common request. But people do it in their application
> code instead?
Actually, my expectation is the other way. I'm continually surprised by posts
on
On Mon, Feb 13, 2012 at 11:51 AM, Steinar Midtskogen
wrote:
> [Scott Hess]
>> Unfortunately, I can't offhand think of a reasonable solution for you,
>> I think I'd just use the SELECT to generate the data, while
>> calculating the moving average in my application code.
>
>
> Actually, my expectation is the other way. I'm continually surprised
> by posts on this list that people expect to be able to use SQLite with
> no external programming at all. I often see complicated compound JOIN
> and sub-SELECT SQL commands here which can be replaced by four lines in
> any
On Mon, Feb 13, 2012 at 12:28 PM, Simon Slavin wrote:
> On 13 Feb 2012, at 7:51pm, Steinar Midtskogen wrote:
>> One should think that the ability to calculate a moving average would
>> be a pretty common request. But people do it in their application
>> code instead?
>
>
Thanks Michael I got it to work.
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Black, Michael (IS)
Sent: Saturday, February 11, 2012 7:57 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Compiling SQLite3
> More generally, I *often* see good C++ programmers pushing application
> logic into SQL, and getting it wrong because they don't really know
> SQL. As a result, my rule of thumb is to make the separation between
> application code and SQL code based on whether the code is filtering
> result
Hi all! Im almost finished with an application of mine that I developed
with M Visual Studio 2010 using c#. The software uses a lot of SQLite
transactions, all of which work perfect compiled and run under Windows.Now I
try to make my app multiplatform, using Mono (for the first time). And I
[Simon Slavin]
> On 13 Feb 2012, at 7:51pm, Steinar Midtskogen wrote:
>
>> One should think that the ability to calculate a moving average would
>> be a pretty common request. But people do it in their application
>> code instead?
>
> Actually, my expectation is the other way. I'm continually
What is the difference between the SQLITE_CONFIG_MULTITHREAD &
SQLITE_CONFIG_SERIALIZED options - When a) the same handle is shared between
multiple threads in a process and when different handles are used by threads in
a proceses.
Is there any difference in concurrency ? What should be used
Please see:
http://system.data.sqlite.org/index.html/doc/trunk/www/faq.wiki#q6
--
Joe Mistachkin
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
29 matches
Mail list logo