Re: [sqlite] error

2007-11-22 Thread nishit sharma
e Phone Solution Team > http://en.xeepe.com > mailto:[EMAIL PROTECTED] > sip:[EMAIL PROTECTED] > > > -Original Message- > From: nishit sharma [mailto:[EMAIL PROTECTED] > Sent: Thursday, November 22, 2007 3:51 PM > To: sqlite-users@sqlite.org > Subject:

[sqlite] syntax error

2007-10-24 Thread nishit sharma
Hi All, Sending y peoples same query with some explanation. i have a database name myds.db which is having one column as index (integer default 0) which has no values in complete database. when i used to access somthing with reference to index in command than i get the error SQL error: near

[sqlite] syntax error

2007-10-24 Thread nishit sharma
Hi All, i have a database in which there is a column named index (integer value). when i m doing select index and all other stuff i m continuosly getting an error that is: SQL error: near "index": syntax error and this error doesn't come if i remove index entry from my command can anybody tell me

[sqlite] passing C variable in query

2007-09-13 Thread nishit sharma
Hi All. can anyone tell me the syntax of passing a C variable in a query. i have taken a variable as float hd= 2000.0; how it'll be passed in a query and what'll be the syntax of that query. regards Nishit

[sqlite] passing variable in statement

2007-09-12 Thread nishit sharma
Hi All, i have taken a variable as int a= 2000; and i m passing this variable in statement as sqlite3_exec(database, select < some column names > from < databasename > where ( X > '" a "')" but i m getting parse error before a. is this the right sequence to follow or there is another thing

[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

[sqlite] function to intialize the structure member

2007-09-06 Thread nishit sharma
Hi All, can anybody tell me which function in sqlite3 can help me in initializing the structure member by reading the values from database. currently i m using sqlite3_exec() function to read the values from database and calling callback function to display the values. can i initialize structure

[sqlite] using loop in sqlite3

2007-09-05 Thread nishit sharma
Hi all, this time i m trying for(g=x-1000:g<=x+1000;g+=d) where g is an integer, x is a define statement which is 2000 and d is an column value from database. now i want to print specific values from database on the basis of g by passing g in the sqlite3_exec() command. my question is it is

Re: [sqlite] C/C++ API

2007-09-05 Thread nishit sharma
hi, in sqlite3 u r having a function named callback whose third argument is used to save the value of a column. u can store that value in an array or in char vairiable also. try this regards Nishit On 9/5/07, "Severin Müller" <[EMAIL PROTECTED]> wrote: > > Hi > > I'm new to sqlite3, and i' have

Re: [sqlite] beginner

2007-09-03 Thread nishit sharma
TED]> wrote: > > You should link the library when you compile .It should be gcc > test.c-l > library name should be your sqlite shared library. Just check in /usr/lib > directory > > Thanks, > Pavan. > > > On 8/31/07, nishit sharma <[EMAIL PROTECTED]&g

Re: [sqlite] beginner

2007-09-03 Thread nishit sharma
can anybody tell me which database formats are supported by sqlite3 and the dependencies if i export my database to another system. regards Nishit On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > hey buddy can u tell me how to compile the C source code in which i

Re: [sqlite] compiling

2007-09-01 Thread nishit sharma
queries in C source code to open, exec and other things to my database without using these argc and argv. waiting for the reply regards Nishit On 8/31/07, John Stanton <[EMAIL PROTECTED]> wrote: > > nishit sharma wrote: > > hi all, > > i have made a sampe which is opening

Re: [sqlite] running code

2007-08-31 Thread nishit sharma
and 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] running code > > > here i am attaching a code > can anyone tell me how to run this code. >

[sqlite] running code

2007-08-31 Thread nishit sharma
here i am attaching a code can anyone tell me how to run this code. waiting for reply #include #include static int callback(void *NotUsed, int argc, char **argv, char **azColName){ int i; for(i=0; i

Re: [sqlite] compiling

2007-08-31 Thread nishit sharma
i have downloaded sqlite-3.4.2.tar.gz<http://www.sqlite.org/sqlite-3.4.2.tar.gz> from the site and i have compiled this but i didn't find any libraries regarding this. can u help me regarding libraries. regards On 8/31/07, nishit sharma <[EMAIL PROTECTED]> wrote: > > it is inc

Re: [sqlite] compiling

2007-08-31 Thread nishit sharma
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 have made

Re: [sqlite] beginner

2007-08-31 Thread nishit sharma
hey buddy can u tell me how to compile the C source code in which i have used sqlite3_open() like calls. i m doing gcc test.c but it is giving me error of undefined reference. i think i am missing some thing in compiling. waiting for reply regards Nishit On 8/30/07, nishit sharma <[EM

[sqlite] compiling

2007-08-31 Thread nishit sharma
hi all, i have made a sampe which is opening a database file but i m unable to compile that source code and getting error that undefined reference to sqlite3_open(). i m compiling as gcc test.c can anybody tell that these is the command to compile sqlite3 application or we have any other command

Re: [sqlite] command

2007-08-30 Thread nishit sharma
using UODATE command its working. thanks for the help regards Nishit On 8/30/07, Jim Dodgen <[EMAIL PROTECTED]> wrote: > > Also I recommend you get a very basic SQL database book. > > > Quoting John Stanton <[EMAIL PROTECTED]>: > > > nishit sharma

[sqlite] command

2007-08-30 Thread nishit sharma
i have given some text in a database file as America|england| and many more. now i want to replace some text with new text how this is possible. Also my database has around 15 rows now which will be incremented. so, plz anyone tell me how to replace a text in a row and how to delete a

Re: [sqlite] beginner

2007-08-30 Thread nishit sharma
thanks for telling the link. regards On 8/30/07, Pavan <[EMAIL PROTECTED]> wrote: > > Hi Nishit, > > http://www.sqlite.org/quickstart.html > > This is a good link to start with. > > Thanks, > Pavan. > > > On 8/30/07, nishit sharma <[EMAIL PR

[sqlite] beginner

2007-08-30 Thread nishit sharma
Hi, i m beginner to sqlite can anybody send me a link which can help me in building and maintining databse