Re: [sqlite] sqlite3_blob_open issue

[Richard Hipp]

On Fri, Oct 11, 2013 at 3:02 AM, Deepika Sathawane <
deepika.sathaw...@igate.com> wrote:

>
> As per the help the database name is not the filename that contains the
> database but rather the symbolic name of the database that appears after
> the AS keyword when the database is connected using ATTACH<
> http://www.sqlite.org/lang_attach.html>. For the main database file, the
> database name is "main". For TEMP tables, the database name is "temp".
>
> How I can find the DB name from SQLite browser/Manager or SQLite function.
>

All valid DB names for your database connection are shown in the second
column of the output of "PRAGMA database_list;"

-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3_blob_open issue

[Deepika Sathawane]

Hi,

I am facing issues while reading the data from blob column. I am not able to 
open the blob. I am using sqlite3_blob_open function.
Can someone provide the sample code for the same.

int sqlite3_blob_open(
  sqlite3*,
  const char *zDb,
  const char *zTable,
  const char *zColumn,
  sqlite3_int64 iRow,
  int flags,
  sqlite3_blob **ppBlob
);

As per the help the database name is not the filename that contains the 
database but rather the symbolic name of the database that appears after the AS 
keyword when the database is connected using 
ATTACH. For the main database file, the 
database name is "main". For TEMP tables, the database name is "temp".

How I can find the DB name from SQLite browser/Manager or SQLite function.

Thanks,
Deepika Sathawane


~~Disclaimer~~~
Information contained and transmitted by this e-mail is confidential and 
proprietary to iGATE and its affiliates and is intended for use only by the 
recipient. If you are not the intended recipient, you are hereby notified that 
any dissemination, distribution, copying or use of this e-mail is strictly 
prohibited and you are requested to delete this e-mail immediately and notify 
the originator or mailad...@igate.com . iGATE does 
not enter into any agreement with any party by e-mail. Any views expressed by 
an individual do not necessarily reflect the view of iGATE. iGATE is not 
responsible for the consequences of any actions taken on the basis of 
information provided, through this email. The contents of an attachment to this 
e-mail may contain software viruses, which could damage your own computer 
system. While iGATE has taken every reasonable precaution to minimise this 
risk, we cannot accept liability for any damage which you sustain as a result 
of softwar
 e viruses. You should carry out your own virus checks before opening an 
attachment. To know more about iGATE please visit www.igate.com 
.

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users