Re: [sqlite] Which API to use to get resultant of query

[sandhya]

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;
}
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]
-----------------------------------------------------------------------------