HI All,
Below is the code.
get_table_data() is giving the expected values.Where as I am not able
get meta info of the same.
sqlite3 *handle;
char *errmsg;
const char *datatype;
const char *colseq;
int NotNull,PrimaryKey,Autoinc;
const char *err;
if(sqlite3_open("temp.db",&handle)==SQLITE_OK)
{
sqlite3_exec(handle,"create table person (integer pid,text
name)",NULL,0,&errmsg);
sqlite3_exec(handle,"insert into person
values(1,\"Ravi\")",NULL,0,&errmsg);
sqlite3_exec(handle,"insert into person
values(2,\"Anand\")",NULL,0,&errmsg);
sqlite3_exec(handle,"insert into person
values(3,\"Sujit\")",NULL,0,&errmsg);
if(sqlite3_table_column_metadata(handle,"temp.db",
"person","pid",&datatype,&colseq,&NotNull,&PrimaryKey,&Autoinc)==SQLITE_
OK)
cout<<"Success";
else
err=sqlite3_errmsg(handle);
Regards,
Ravi K
-----Original Message-----
From: Glenn [mailto:[EMAIL PROTECTED]
Sent: Sunday, November 12, 2006 9:16 PM
To: [email protected]
Subject: Re: [sqlite] sqlite3_table_column_metadata????
[EMAIL PROTECTED] wrote:
> Hi All,
>
> The function sqlite3_table_column_metadata() is giving the
> error message "No such TableName.ColName" even if I pass correct table
> name and col name
>
> (All the parameters are correct).
>
> Is there any problem with the API or Any extra care needs to be Taken?
>
> Please let me Know ASAP. I am totally struck!!!!
Providing your code which is calling sqlite3_table_column_metadata()
would help. Just saying that you are calling it correctly doesn't give
anyone a place to investigate; if you are calling everything correctly
then it should work.
--
Glenn McAllister <[EMAIL PROTECTED]> +1 416 348 1594
SOMA Networks, Inc. http://www.somanetworks.com/ +1 416 977 1414
------------------------------------------------------------------------
-----
To unsubscribe, send email to [EMAIL PROTECTED]
------------------------------------------------------------------------
-----
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contain proprietary, confidential or privileged information. If you are not the
intended recipient, you should not disseminate, distribute or copy this e-mail.
Please notify the sender immediately and destroy all copies of this message and
any attachments.
WARNING: Computer viruses can be transmitted via email. The recipient should
check this email and any attachments for the presence of viruses. The company
accepts no liability for any damage caused by any virus transmitted by this
email.
www.wipro.com
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
