Hello,
You can take a look at http://sqlite.phxsoftware.com/forums/t/31.aspx
where you can find the DataType mappings for the .NET provider.
Be careful also with
DOUBLE -> DbType.Double
FLOAT -> DbType.Double
REAL -> DbType.Single
Xevi
2011/5/19 Joe D :
>
> I have an app that creates a table o
Hi,
I have the following sqlite trigger:
/
/|/CREATE TRIGGER DLT_actymethods_ibfk_1 BEFORE DELETE ON activity FOR
EACH ROW BEGIN DELETE FROM actymethods WHERE ACTY_COD = OLD.ACTY_COD; END/
|So before delete the row from the table activity delete all records
from the table actymethods associated
On Wed, May 18, 2011 at 9:50 PM, Richard Hipp wrote:
> On Wed, May 18, 2011 at 1:27 PM, Nico Williams wrote:
>> Also, I didn't expect commits and branches to go to the repository
>> that I cloned mine from. That was surprising! With git and other
>> similar VCSes such operations only hit the rep
On Wed, May 18, 2011 at 9:44 PM, Richard Hipp wrote:
> You need tclsqlite3.c, not sqlite3.c. main() is found in tclsqlite3.c. The
> comment in the Makefile is not clear on this point and needs to be fixed
Oh, duh. Thanks!
Nico
--
___
sqlite-user
On Wed, May 18, 2011 at 1:27 PM, Nico Williams wrote:
> So I've stumbled twice trying to set up use of Fossil, both times with
> respect to how to create a private branch.
>
> First I did "fossil branch new ..." and didn't realize that the
> workspace was not switched to be in that branch, so that
On Wed, May 18, 2011 at 6:05 PM, Nico Williams wrote:
> The SQLite3 docs Fossil repository doesn't seem to include any
> instructions for building the docs. I've searched sqlite.org up and
> down (docs and wiki both) for these instructions. I've also searched
> the web a bit and found nothing ob
I have an app that creates a table of file names and sizes. The app
itself works fine.
I wanted to look at the table just to make sure that it was doing what
it should, so I used something to do a simple SELECT * and bind the
results to a DataGrid.
When I did, I got an error "Value was eithe
On May 19, 2011, at 12:28 AM, Igor Tandetnik wrote:
> That's SQLite extension. I don't believe it's legal standard SQL. The
> alias in the SELECT clause acts kind of like a macro; its use in the
> rest of the statement is simply replaced with the corresponding expression.
Mind-boggling. Border
On 5/18/2011 6:11 PM, Petite Abeille wrote:
> In other words, how come the following works in SQLite:
>
> select 1 as value where value> 0;
>
> Or even weirder:
> select 1 as value where value = 0;
>
> There is no from clause, there is no column 'value' per se, but nonetheless
> that non existing
On Wed, May 18, 2011 at 5:11 PM, Petite Abeille
wrote:
> Where does the start_gap and end_gap come from? They are only declared in the
> select part of the inner select statement, and nowhere in the from part. But
> nonetheless, SQLite manages to use these non existing columns in the where
> cl
On May 18, 2011, at 11:28 PM, Igor Tandetnik wrote:
> On 5/18/2011 4:17 PM, Pavel Ivanov wrote:
>>> I need help to build a statement in order to select all days free from
>>> events in a specific time range.
>>
>> This kind of task should be implemented in your application. SQL
>> wasn't intende
The SQLite3 docs Fossil repository doesn't seem to include any
instructions for building the docs. I've searched sqlite.org up and
down (docs and wiki both) for these instructions. I've also searched
the web a bit and found nothing obvious. I have figured out something
from the file named main.m
Amazing!
Thanks a lot.
2011/5/18 Igor Tandetnik :
> select startGap, min(endGap) from
> (
> select date(e1.endDate, '+1 day') startGap, date(e2.startDate, '-1
> day') endGap
> from (select startDate, endDate from events
> union all
> select '' startDate, date('2011-01-01', '-1
On 18 May 2011, at 9:09pm, Brancke, Brad wrote:
> Once in a while when we power on the device and start my application,
> this query fails:
>
> "SELECT storage_enum, mode, GPSDisplayDMS, UserRealID, UserEffID FROM
> Settings;"
>
> with the reason "unable to open database file"
I assume that t
On 5/18/2011 4:17 PM, Pavel Ivanov wrote:
>> I need help to build a statement in order to select all days free from
>> events in a specific time range.
>
> This kind of task should be implemented in your application. SQL
> wasn't intended for and can't solve such tasks.
Sounds like a challenge:
s
On Wed, May 18, 2011 at 4:10 PM, Petite Abeille
wrote:
> On May 18, 2011, at 10:50 PM, Danilo Cicerone wrote:
>> How can I simulate a
>> calendar table(maybe using the strftime funtion)?
>
> Well, you have two broad options:
>
> (1) materialize the calendar as a table
> (2) virtualize the calendar
On Wed, May 18, 2011 at 4:14 PM, Petite Abeille
wrote:
> Very nice, thanks for sharing :)
>
> Wish such a functionality was part of the stock SQLite :))
Thanks for the kind words! I will do my best to make it palatable and
hopefully desirable for the core dev team to integrate my patches. I
don
On May 16, 2011, at 7:30 PM, Nico Williams wrote:
> In my next post I'll post a [681 line, 28KB unified diff, or 504 line
> regular diff] patch implements the following DB triggers:
>
> - AFTER DATABASE CONNECT
> - AFTER TRANSACTION BEGIN
> - BEFORE TRANSACTION COMMIT
Very nice, thanks for shar
Thanks again.
2011/5/18 Petite Abeille :
>
> On May 18, 2011, at 10:50 PM, Danilo Cicerone wrote:
> (1) materialize the calendar as a table
> (2) virtualize the calendar as a generator
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite
On May 18, 2011, at 10:50 PM, Danilo Cicerone wrote:
> How can I simulate a
> calendar table(maybe using the strftime funtion)?
Well, you have two broad options:
(1) materialize the calendar as a table
(2) virtualize the calendar as a generator
The first option is brutal, but simple. E.g. cre
Thanks Petite,
I get it, great. Only another quick question, How can I simulate a
calendar table(maybe using the strftime funtion)?
Danilo
2011/5/18 Petite Abeille :
>
> On May 18, 2011, at 10:17 PM, Pavel Ivanov wrote:
>
>> SQL wasn't intended for and can't solve such tasks.
>
> Of course it can.
On May 18, 2011, at 10:17 PM, Pavel Ivanov wrote:
> SQL wasn't intended for and can't solve such tasks.
Of course it can.
Assuming a calendar and an event table:
select calendar.date
from calendar
where calendar.date between '20110101' and '20110201'
and not exists ( select 1 from event whe
> I need help to build a statement in order to select all days free from
> events in a specific time range.
This kind of task should be implemented in your application. SQL
wasn't intended for and can't solve such tasks.
Pavel
On Wed, May 18, 2011 at 4:06 PM, Danilo Cicerone wrote:
> Hi to al
Dear SQL gurus -
I have been using SQLite for several years and love it. Currently it is
being used on a small embedded Linux device.
Once in a while when we power on the device and start my application,
this query fails:
"SELECT storage_enum, mode, GPSDisplayDMS, UserRealID, UserEffID FROM
Hi to all,
I need help to build a statement in order to select all days free from
events in a specific time range.
E.g.:
- Range(-MM-DD) from 2011-01-01 to 2011-02-01.
- Event 1 from 2011-01-02 to 2011-01-08
- Event 2 from 2011-01-06 to 2011-01-12
- Event 3 from 2011-01-18 to 2011-01-21
Resul
So I've stumbled twice trying to set up use of Fossil, both times with
respect to how to create a private branch.
First I did "fossil branch new ..." and didn't realize that the
workspace was not switched to be in that branch, so that my subsequent
commit didn't go to that branch.
My second attem
On Wed, May 18, 2011 at 11:06 AM, Nikolaus Rath wrote:
>
> So considering this as feature request: do you have any thoughts on
> making SQLite consider auto-checkpointing when a read transaction
> finishes?
>
There might be performance implications. But we'll look into it.
--
D. Richard Hip
Richard Hipp writes:
> On Tue, May 17, 2011 at 5:11 PM, Nikolaus Rath
> wrote:
>> Please consider the attached testcase. The WAL file should grow to at
>> most 1 MB. This limit is exceeded, because the script adds data while a
>> second cursor has an active SELECT query. However, when the SELECT
On Tue, May 17, 2011 at 5:11 PM, Nikolaus Rath wrote:
> Hi,
>
> Please consider the attached testcase. The WAL file should grow to at
> most 1 MB. This limit is exceeded, because the script adds data while a
> second cursor has an active SELECT query. However, when the SELECT query
> finishes, th
On 17 mai 2011, at 19:16, irfan khan wrote:
Thanks a lot for your replay.
But we are developing new application for ipad for some buisseness need and
need to configure sqllite database for the same.
I am MS SQL database administrator and my developer team asked me to
configure sqlite for ipad.
30 matches
Mail list logo
