Re: [sqlite] Conditional execution

2007-09-11 Thread Joe Wilson
insert into tab2 select * from tab3 where exists (select * from tab1) union all select * from tab4 where not exists (select * from tab1); Joe "Igor" Wilson --- Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote: > Is it possible to write a conditional SQL code like this? CASE > expression does

[sqlite] Re: Conditional execution

2007-09-11 Thread Igor Tandetnik
Yuriy Martsynovskyy <[EMAIL PROTECTED]> wrote: Is it possible to write a conditional SQL code like this? CASE expression does not seem to work here IF (exists (Select * from tab1)) THEN Insert into tab2 select * from tab3 ELSE Insert into tab2 select * from tab4 ENDIF; Something like this is

[sqlite] monitoring inserts

2007-09-11 Thread Mike Johnston
It seems clunky no real specific reason. I tried it out today and it's quite fast and simple. I'm not sure I could say the same thing about a lot of IPC stuff. thanks - Boardwalk for $500? In 2007? Ha! Play Monopoly Here and Now (it's updated for

[sqlite] Conditional execution

2007-09-11 Thread Yuriy Martsynovskyy
Is it possible to write a conditional SQL code like this? CASE expression does not seem to work here IF (exists (Select * from tab1)) THEN Insert into tab2 select * from tab3 ELSE Insert into tab2 select * from tab4 ENDIF;

Re: [sqlite] Monitoring for inserts

2007-09-11 Thread Dan Kennedy
On Tue, 2007-09-11 at 07:49 -0700, Mike Johnston wrote: > What is the best way to get notified a table changed? > I would like to monitor a table for inserts without > resorting to polling. Anyway to have a trigger call > a 'C' function or something? There is, but it will only be called in

[sqlite] Monitoring for inserts

2007-09-11 Thread Mike Johnston
What is the best way to get notified a table changed? I would like to monitor a table for inserts without resorting to polling. Anyway to have a trigger call a 'C' function or something? TIA, Mike - Yahoo! oneSearch: Finally, mobile search that gives

Re: [sqlite] Re: data base locked problem

2007-09-11 Thread Armin Steinhoff
"Igor Tandetnik" <[EMAIL PROTECTED]> schrieb am 11.09.2007 13:40:30: > > Armin Steinhoff wrote: > > if we are try to create a new data base with sqlite > > we see the following error outputs: > > > > # sqlite x.db > > OPEN3 /appl/sbin/x.db > > OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D > >

Re: [sqlite] extension-functions.tgz for sqlite3 3.4.1 ?

2007-09-11 Thread Nuno Lucas
On 9/10/07, Joe Wilson <[EMAIL PROTECTED]> wrote: > --- Liam Healy <[EMAIL PROTECTED]> wrote: > > Thanks for the tip Joe. With sqlite3.h included, I can eliminate os.h and > > vdbeInt.h, but not sqliteInt.h. Apparently sqliteInt.h is not included by > > sqlite3.h, and there are typedefs there

[sqlite] Re: data base locked problem

2007-09-11 Thread Igor Tandetnik
Armin Steinhoff wrote: if we are try to create a new data base with sqlite we see the following error outputs: # sqlite x.db OPEN3 /appl/sbin/x.db OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D SQLite version 2.8.0 Enter ".help" for instructions sqlite> create table yy(xx char(10), x int); SQL

[sqlite] Re: passing float data types

2007-09-11 Thread Igor Tandetnik
nishit sharma <[EMAIL PROTECTED]> wrote: sqlite3_exec(database,"select name, phone, logo from databaseentry where (x_add > 0.0) and (x_add<3000.0) which is working fine and giving me results in between these limits. but how can i pass upper comparison in sqlite3_exec() statement. Don't use

[sqlite] data base locked problem

2007-09-11 Thread Armin Steinhoff
Hello, if we are try to create a new data base with sqlite we see the following error outputs: # sqlite x.db OPEN3 /appl/sbin/x.db OPEN-EX 4 /tmp/sqlite_Iihb60vuQk4Nf9D SQLite version 2.8.0 Enter ".help" for instructions sqlite> create table yy(xx char(10), x int); SQL error: database

[sqlite] passing float data types

2007-09-11 Thread nishit sharma
Hi All, first i give an example of what i am doing: i have taken few data types as: float logx= x - 2000.0; loat logx1= x + 2000.0 float logy= y- 3000.0; float logy1= y + 3000.0; where x and y are define statements which are 2000.0 and 4000.0 i have an column of x_add and y_add in my database. i