sandhya a écrit :
You mean there is no need for me to take care of this function calls ..Its
just enough having definition there.
But by doing that i am not getting any kind of output ie my OID.
No you should write the callback and do whatever you want with the
passed data.
You the pass the call_back name to the relevant sqlite function.
sqlite will call it for every row selected by your query.
----- Original Message -----
From: "Noel Frankinet" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 8:02 PM
Subject: Re: [sqlite] Which API to use to get resultant of query
sandhya a écrit :
Thanks a lot for your response
Actually there is one function call in some sample found like,
static int callback(void *NotUsed, int argc, char **argv, char
**azColName)
{
int i;
for(i=0; i<argc; i++){
printf("%s = %s\n", azColName[i], argv[i] ? argv[i] : "NULL");
}
printf("\n");
return 0;
}
you don't call that callback , its called by sqlite...
In your case argc will be 1, argv[0] will contains the oid and
azColNames[0] will be "oid"
I reffered Shell.c also where in they also has the same function,If i am
not
passing my arguments through command prompt...
What i should pass as 2 and 3 arguments in the above function call ie
argc
and argv.Is there any API which directly gives the result.
Actually my query is returing only one data ie OID of the file....In
this
case what i can do to get that data.Where it will get stored?
Please help me...in doing this
Thank you
Sandhya
----- Original Message -----
From: "Jay Sprenkle" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Friday, September 15, 2006 7:38 PM
Subject: Re: [sqlite] Which API to use to get resultant of query
On 9/15/06, sandhya <[EMAIL PROTECTED]> wrote:
sprintf(szQuery,"select oid from %s where filename =
'%s'",sampletbl,test.htm);
there's an example program here:
http://sqlite.org/quickstart.html
and a more involved one here
http://www.reddawn.net/~jsprenkl/Sqlite
--
--
SqliteImporter and SqliteReplicator: Command line utilities for Sqlite
http://www.reddawn.net/~jsprenkl/Sqlite
Cthulhu Bucks!
http://www.cthulhubucks.com
-------------------------------------------------------------------------
-
---
To unsubscribe, send email to [EMAIL PROTECTED]
-------------------------------------------------------------------------
-
---
--------------------------------------------------------------------------
---
To unsubscribe, send email to [EMAIL PROTECTED]
--------------------------------------------------------------------------
---
--
Noël Frankinet
Gistek Software SA
http://www.gistek.net
--------------------------------------------------------------------------
---
To unsubscribe, send email to [EMAIL PROTECTED]
--------------------------------------------------------------------------
---
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
--
Noël Frankinet
Gistek Software SA
http://www.gistek.net
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
