[sqlite] beginner

Hi, i m beginner to sqlite can anybody send me a link which can help me in building and maintining databse

Re: [sqlite] beginner

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] command

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] command

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] compiling

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] compiling

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

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

Re: [sqlite] compiling

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] running code

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

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

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] beginner

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] beginner

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] C/C++ API

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

[sqlite] using loop in sqlite3

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

[sqlite] function to intialize the structure member

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] passing float data types

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] passing variable in statement

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 C variable in query

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] syntax error

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] syntax error

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

Re: [sqlite] error

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: