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 w
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
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 sql
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 e
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 tha
"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
> > SQ
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 a
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 th
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?
You can create a custom function with sqlite3_create_function. A trigger
can then d
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;
--
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 today
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 b
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 n
13 matches
Mail list logo