Re: [sqlite] reg:Sqlite API's

[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
To: 
Sent: Friday, September 15, 2006 6:31 PM
Subject: Re: [sqlite] reg:Sqlite API's


> sandhya wrote:
> > Hi all,
> >Can you please tell me the usage of sqlite_prepare()
/sqlite_exec()
> Have you looked at the SQLite source code? The stand-alone executable
> should be of help. I believe it is shell.c
>
> HTH,
>
> Gerry
>
> --
---
> To unsubscribe, send email to [EMAIL PROTECTED]
> --
---
>



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] reg:Sqlite API's

[Gerry Snyder]

sandhya wrote:

Hi all,
   Can you please tell me the usage of sqlite_prepare() /sqlite_exec()
Have you looked at the SQLite source code? The stand-alone executable 
should be of help. I believe it is shell.c


HTH,

Gerry

-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] reg:Sqlite API's

[sandhya]

Hi all,
   Can you please tell me the usage of sqlite_prepare() /sqlite_exec() inorder 
to execute a query say for example,
I have given a query like ,

strcpy(szQuery," SELECT OID from table sample where name ="XXX"");

I have used sqlite_exec(db,szQuery,0,0,0);

Where my resultant data will get stored.Can any one please tell me how to 
retrieve the result from the above API.

I saw in documentation that we can also use sqlite_prepare() is there any 
difference btn these two.Which i can use?
How to get the resultant data from this API?
Very new to this so little bit confused with these API's.Is there any document 
which explains how to work with the sqlite with some samples.Please do mail me 
the link so i will be very thankful to you.This is very much required for me to 
complete my task with in short period.

Kindly do needful...Looking forward for ur reply

Thank you very much
Sandhya R