I hope that you know that
sprintf(sql, "SELECT count(*) FROM table1;");
is not a going to give you count(*) FROM table1.
Where is your real query?
________________________________
From: Prajeed chathuar <prajee...@dwisesolutions.com>
To: sqlite-users@sqlite.org
Sent: Thu, May 13, 2010 4:10:01 AM
Subject: [sqlite] API not responding correctly for vc++
Hi
I am a sotware trainee of Bangalore,India base company...i am working for
the first time in sqlite data baase..
I am trying sqlite and vc++ for last one week iam not getting correct
output.....there is no linking and compiling error but not getting correct
output: here is the code
int sqlresult = 1;
char sql[1024]="";
int rc;
sprintf(sql, "SELECT count(*) FROM table1;");
rc = sqlite3_open("sqlite3pp.db", &db);
if ( rc )
{
MessageBox("Unable to open database for record count","Database
Result",MB_OK | MB_ICONERROR);
}
In the above code my program is always returning 0X0000000(some hexadecimal
value)from sqlite3_open() . The data base is in the folder where the
solution file is residing......i have included the sqlite3.lib file also
which was extracted from sqlite3.def.
Can any help me for the above problem
Thanks
Prajeed.c
Software trainee
Dwise solutions,Bangalore,India
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
