mn_int64(ppStmt ,0);
}
sqlite3_finalize( ppStmt );
This should do it
--
Bharath
On 1/31/08 11:00 AM, "kirrthana M" <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Im using the query Select count(*) from table to get the no of rows in the
> table in my c code.
> In the comma
Hi all,
Im using the query Select count(*) from table to get the no of rows in the
table in my c code.
In the command line it will print the no of rows ,but in my c code how can i
get the result,
should i use prepare and step in this case and where the result of the query
will be stored on executi
Hi all,
I just want to compare the performance of sqlite on various os and in
embedded,
Just want to know the time it takes to read and write data,can anybody give
me a suggestion of how to do this.
Regards
Kirrthana
The information contained in this electronic message and any attachments to
t
You would have not closed the database after usage,just check wheather you
have closed the database.
-Original Message-
From: varunkumar [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 09, 2007 9:25 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] sqlite3_exec function error:database is l
In the sql query use AND operator for the two columns you want to compare.
Ex:select * from table_name where col1=="value" AND col2 == "value";
-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Monday, September 03, 2007 3:41 PM
To: sqlite-users@sqlite.org
Subject: Re:
Your test1.o with 2 arguments
first will be the name of the database and the second will be some sql
command to be executed.
-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Friday, August 31, 2007 5:13 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] runnin
I think you have not included header file "sqlite3.h" in your code,if u have
not included include and compile again.
-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Friday, August 31, 2007 12:45 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] compiling
hi all,
i h
Update can be used to replace a text with some new text.
To delete a particular row use 'where' command along with
'delete'.
-Original Message-
From: nishit sharma [mailto:[EMAIL PROTECTED]
Sent: Thursday, August 30, 2007 4:04 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] command
i h
Thanks i ll check it out..
-Original Message-
From: Lloyd [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 1:37 PM
To: Kirrthana M
Cc: sqlite-users@sqlite.org
Subject: Re: [sqlite] Copying the content of a table to another table
create table x(c1 number,c2 number);
create table
Hi all,
I have created a table with two columns c1 and c2 and inserted some
values into,in future i may include some additional columns c3,c4. to
the same table.In tat case i should not loose my data in the current
table,so i should be able to copy the content of the current table(value
By getting the search string from previous table im not only retrieving data
from the table4,at each step i have to retrieve data from 3 tables and store
it in the data structure.
-Original Message-
From: T&B [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 14, 2007 3:35 PM
To: sqlite-user
I have four tables like Mytable1,Mytable2,Mytable3,Mytable4
Mytable1 and Mytable2 have one similar field rest al different,
Mytable2 and Mytable3 have one similar field rest al different,
Mytable3 and Mytable4 have one similar field rest al different,
i have to select from four tables by matching
Hi all,
I have created a database with four tables,i have to search and retrieve
data from all the four tables based on the entry i get from the previous
table and display all the entries,could anybody tell how to do it.
Regards
Kirrthana
Hi everybody,
Im developing an application using sqlite3 in MAC OS,I just wanted to
know wheather sqlite3 can be used in MAC OS.If so can the same sqlite3
library and the executable used in windows can be used in MAC OS or a
different version has to be used.
Regards,
Kirrthana
Hi,
In my query for inserting values into the database i have a statement as
given below
insert into table_name values('I haven't done that');
table is created with this option
create table table_name(str varchar(20));
when the insert statement is executed it gives the error in haven't,It is
wor
Hi,
Im new to sqlite,i have written a program to create a table and perform
the following operations
Insert,Delete,search.
To perform a search i used the query SELECT along with
sqlite3_exec..Execution is successful but the result is not displayed in the
screen.how to retrieve the result.Give me
16 matches
Mail list logo