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:
After making command i m getting this error
select * from databaseentry where Sub="BarsandPubs" limit 5 order by
Button_Name;
SQL error: near "order": syntax error
can anybody help
regards
Nishit
-
To unsubscribe, send
thnx for the help
regards
Nishit
On 10/24/07, Markus Hoenicka <[EMAIL PROTECTED]> wrote:
>
> Quoting nishit sharma <[EMAIL PROTECTED]>:
>
> > Hi All,
> > Sending y peoples same query with some explanation.
> > i have a database name myds.db which i
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 "index"
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
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
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
waitin
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
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 me
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 possi
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
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]>
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
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
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.
>
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-
To unsubscribe,
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 i
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
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
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
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 wrot
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 particular
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 PROTE
Hi,
i m beginner to sqlite
can anybody send me a link which can help me
in building and maintining databse
24 matches
Mail list logo