Re: [sqlite] Adding data with periods

Hi, Sqlite takes the period as a special character. Wherever you get a period ' make it as ''. This will make it as a normal character and will work fine. Hope the solution solves your problem. Regards, Kirrthana -Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite

RE: [sqlite] Getting the no of rows using count(*)

It works fine..Thanks.. Kirrthana -Original Message- From: Bharath Booshan L [mailto:[EMAIL PROTECTED] Sent: Thursday, January 31, 2008 12:07 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Getting the no of rows using count(*) Hello Kirrthana, > should i use prepare and s

[sqlite] Getting the no of rows using count(*)

on executing my c code. Regards Kirrthana The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should

[sqlite] Checking out the performance of sqlite3

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

RE: [sqlite] beginner

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: [sqlite] running code

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]

RE: [sqlite] compiling

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

RE: [sqlite] command

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

RE: [sqlite] Copying the content of a table to another table

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

[sqlite] Copying the content of a table to another table

(values of c1 and c2) to the new table and start working with the new table and delete the existing one,could anybody give me a suggestion for doing this. Regards Kirrthana

RE: [sqlite] retrieving data from multiple tables

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 [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 14, 2007 3:35 PM To:

RE: [sqlite] retrieving data from multiple tables

with all these field. -Original Message- From: T [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 14, 2007 12:44 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] retrieving data from multiple tables Hi Kirrthana, > I have created a database with four tables,i have to sea

[sqlite] retrieving data from multiple tables

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

[sqlite] Sqlite3 in MAC Os

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

[sqlite] Usage of special characters in insert query

,It is working fine if i remove the apostrophe, but my input string will contain the apostrophe.. Give me a suggestion for rectifying this Thanks, Kirrthana

[sqlite] how to use the query select with sqlite3_exec

a suggestion. Thanks, Kirrthana