[sqlite] Fwd: bulk upload from Excel

[Jean-Christophe Deschamps]

>-- Forwarded message --
>From: "maksood alam" <786maksood at gmail.com>
>Date: May 11, 2015 11:21 AM
>Subject: bulk upload from Excel
>To: 
>Cc:
>
>Hi Team,
>
>Do we have any option like below for the bulk upload.
>
>INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" &
>ThisWorkbook.FullName & "' 'Excel 8.0;'"

You could use AutoIt (freeware) which offers support for both Excel and 
SQLite.

This is a basic-type Windows scripting language with a load of features 
to ease automation up to create real-world applications.

JcD 

[sqlite] Suggestion for .import improvement

[to...@acm.org]

I would like to request this improvement to the shell .import command.  (Wish 
list, I guess.)

Current .import behavior is that when the imported table does not exist, it 
will be created using the first row from the data file as column names for the 
new table.

This is great but it has one problem:

Example use case: Loading phone call logs.  Each month a new file with just 
that month?s activity needs to be inserted.  So, old data has to remain as is, 
and new data added to the table.  The format of the file is always the same: 
header row followed by data rows.

Once the initial table is created by the first .import, every subsequent time 
.import will add the header row again and again as data.

My suggestion to avoid this is to behave like so, instead:

1. If the table does not exist, the same as current behavior: Create table 
using first row for column names.
2. If the table exists, and the first row matches the column names, skip the 
first row, and continue inserting the rest of the rows.
3. If the table exists, and the first row does not match the column names, 
treat as data, and insert into table.  (This takes care if the file has no 
longer header row, or manually edited out.)

Is this possible?

It?s a real nuisance to have to edit out the headers every time, especially 
when the files are very large and they do not load fast (or at all) into a text 
editor.  Plus, it?s semi-automatic.
(I know I could write a Lua/Python script to do this filtering but I think it 
would be simpler and more immediate if the SQLite shell could take care of it 
directly.)

Thank you.

[sqlite] Fwd: bulk upload from Excel

[Peter Aronson]

I don't know what happened to my links in the previous email. ?Again:
http://www.gdal.org/ogr_sql_sqlite.html
http://www.gdal.org/drv_sqlite.html
?


 On Monday, May 11, 2015 12:01 PM, Peter Aronson  
wrote:



 It's a little indirect, but starting with GDAL 1.10, if you have a version oft 
he GDAL dynamic library built with both SQLite support and XLS and/or XLSX 
support (depending on which you need), you can load the GDAL library as a 
SQLite extension using the load_extension SQL function, and then create a 
virtual table of an Excel spread-sheet using the VirtualOGR module (see 
http://www.gdal.org/drv_sqlite.html?and?http://www.gdal.org/ogr_sql_sqlite.html).
 ?There might be a simpler approach, of course.
Peter?


? ? On Monday, May 11, 2015 11:08 AM, maksood alam <786maksood at gmail.com> 
wrote:
? 


 -- Forwarded message --
From: "maksood alam" <786maks...@gmail.com>
Date: May 11, 2015 11:21 AM
Subject: bulk upload from Excel
To: 
Cc:

Hi Team,

Do we have any option like below for the bulk upload.

INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" &
ThisWorkbook.FullName & "' 'Excel 8.0;'"
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users



? 
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Fwd: bulk upload from Excel

[Peter Aronson]

It's a little indirect, but starting with GDAL 1.10, if you have a version oft 
he GDAL dynamic library built with both SQLite support and XLS and/or XLSX 
support (depending on which you need), you can load the GDAL library as a 
SQLite extension using the load_extension SQL function, and then create a 
virtual table of an Excel spread-sheet using the VirtualOGR module (see 
http://www.gdal.org/drv_sqlite.html?and?http://www.gdal.org/ogr_sql_sqlite.html).
 ?There might be a simpler approach, of course.
Peter?


 On Monday, May 11, 2015 11:08 AM, maksood alam <786maksood at gmail.com> 
wrote:



 -- Forwarded message --
From: "maksood alam" <786maks...@gmail.com>
Date: May 11, 2015 11:21 AM
Subject: bulk upload from Excel
To: 
Cc:

Hi Team,

Do we have any option like below for the bulk upload.

INSERT INTO tbl_test1 SELECT * FROM [asd$] IN '" &
ThisWorkbook.FullName & "' 'Excel 8.0;'"
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] VBA Sqllite blob data

[Daniel Sjödin]

Hi,

Have a look at the last post in this thread. Never tested this but if true
then maybe it's an idea to try to implement it in vba part of
sqliteforexcel.

http://stackoverflow.com/questions/2516702/getting-around-the-max-string-size-in-a-vba-function

Regards,
Daniel
Den 11 maj 2015 18:17 skrev "Bart Smissaert" :

> What is in the blob?
> What are you trying to see when you dump it to the sheet?
>
> RBS
>
> On Mon, May 11, 2015 at 2:27 PM, Preston King 
> wrote:
>
> > I have a db3 config file that contains several different records. I need
> > to select one specific record and store it in an excel worksheet cell. I
> > have been able to create a routine to extract the information that I need
> > once I get the record into a worksheet cell. The problem that I have run
> > into is the record is longer than 255 characters and gets truncated at
> that
> > limit.
> >
> >
> > -Original Message-
> > From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:
> > sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Bart
> Smissaert
> > Sent: Friday, May 08, 2015 5:23 PM
> > To: General Discussion of SQLite Database
> > Subject: Re: [sqlite] VBA Sqllite blob data
> >
> > What do you mean with: into Excel? Into a cell in the worksheet, into a
> > VBA variable?
> > What code did you try? I never use blobs, but I don't think it should be
> a
> > problem.
> >
> > RBS
> >
> >
> >
> > On Fri, May 8, 2015 at 8:15 PM, Preston King 
> > wrote:
> >
> > > Does anyone have an example of how to read sqlite blob records, that
> > > are not pictures, into Excel? I have been trying to find some VBA code
> > > to do this but am not having much luck. Thanks
> > > ___
> > > sqlite-users mailing list
> > > sqlite-users at mailinglists.sqlite.org
> > > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > >
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Suggestion for .import improvement

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 05/11/2015 12:24 PM, tonyp at acm.org wrote:
> It?s a real nuisance to have to edit out the headers every time,
> especially when the files are very large and they do not load fast
> (or at all) into a text editor.  Plus, it?s semi-automatic.

I suggest you use a simpler way.  Create a temporary table and do the
.import into that.  You can then copy that table into your desired one:

  BEGIN
  CREATE TEMPORARY TABLE temptable .;
  .import log.csv temptable
  INSERT INTO desired SELECT * from temptable;
  COMMIT

You can explicitly delete the temp table, or it will automatically go
away when you close the connection.

The advantage of this approach is you can do processing on the
temporary table (eg convert nulls to empty string or vice versa, drop
header row), add a column (eg import date), have different columns
and/or names between the two (adjust the INSERT/SELECT statement) etc.
 This will all work from the shell, requires no programming, and will
import just as fast.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlVRVTYACgkQmOOfHg372QREYwCePcN1Z5RauOs7lo4jvtLNyx+t
018AnRJpES+JhBR5kM3+7m4Fa2p1I9t6
=oss6
-END PGP SIGNATURE-

[sqlite] VBA Sqllite blob data

[Bart Smissaert]

What is in the blob?
What are you trying to see when you dump it to the sheet?

RBS

On Mon, May 11, 2015 at 2:27 PM, Preston King  wrote:

> I have a db3 config file that contains several different records. I need
> to select one specific record and store it in an excel worksheet cell. I
> have been able to create a routine to extract the information that I need
> once I get the record into a worksheet cell. The problem that I have run
> into is the record is longer than 255 characters and gets truncated at that
> limit.
>
>
> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:
> sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of Bart Smissaert
> Sent: Friday, May 08, 2015 5:23 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] VBA Sqllite blob data
>
> What do you mean with: into Excel? Into a cell in the worksheet, into a
> VBA variable?
> What code did you try? I never use blobs, but I don't think it should be a
> problem.
>
> RBS
>
>
>
> On Fri, May 8, 2015 at 8:15 PM, Preston King 
> wrote:
>
> > Does anyone have an example of how to read sqlite blob records, that
> > are not pictures, into Excel? I have been trying to find some VBA code
> > to do this but am not having much luck. Thanks
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>

[sqlite] Please confirm what I THINK I know about blobs

[Eduardo Morras]

On Mon, 11 May 2015 14:00:41 +
"Drago, William @ CSG - NARDA-MITEQ"  wrote:


> Correct me if I'm wrong, but the only way to read comments is by
> reading back the entire CREATE TABLE string, correct?

Yes, you need to parse it. You search for '--' and '\n'. The chars between them 
are the comment. 

I thought you need it only for documentation purpouse and not automatic/dynamic 
programming.

> Thanks,

---   ---
Eduardo Morras 

[sqlite] Issue: Inconsistency of sqlite3_dbstat_register declaration

[Jan Nijtmans]

2015-05-11 16:33 GMT+02:00 Roger Binns :
> On 05/11/2015 01:34 AM, Jan Nijtmans wrote:
>> 2) If sqlite is not compiled with -DSQLITE_ENABLE_DBSTAT_VTAB=1,
>> or the function is renamed (as it should) it wouldn't even work.
>
> That was my scenario.  I just -DSQLITE_ENABLE_DBSTAT_VTAB and the code
> didn't compile because of the inconsistency.

Well, it's fixed now on trunk!  Thanks, Richard!



Regards,
Jan Nijtmans

[sqlite] VBA Sqllite blob data

[Jean-Christophe Deschamps]

Hi Simon,

>On 11 May 2015, at 3:25pm, Jean-Christophe Deschamps 
> wrote:
>
> > Isn't that the actual size limit of Excel strings?
>
>Sort of.  Although Excel cells can contain text longer than 255 
>characters, VBA functions ignore text parameters after the 255th 
>character.  This is because VBA, when originally written, used 
>Pascal-type strings internally.
>
>Simon.

Yes, I meant "using either VBA or COM objects". People regularly 
complain that they hit this limit when using Excel with AutoIt (the 
communication uses COM).

JcD 

[sqlite] VBA Sqllite blob data

[Jean-Christophe Deschamps]

Isn't that the actual size limit of Excel strings?

At 15:27 11/05/2015, you wrote:

>I have a db3 config file that contains several different records. I 
>need to select one specific record and store it in an excel worksheet 
>cell. I have been able to create a routine to extract the information 
>that I need once I get the record into a worksheet cell. The problem 
>that I have run into is the record is longer than 255 characters and 
>gets truncated at that limit.
>
>
>-Original Message-
>From: sqlite-users-bounces at mailinglists.sqlite.org 
>[mailto:sqlite-users-bounces at mailinglists.sqlite.org] On Behalf Of 
>Bart Smissaert
>Sent: Friday, May 08, 2015 5:23 PM
>To: General Discussion of SQLite Database
>Subject: Re: [sqlite] VBA Sqllite blob data
>
>What do you mean with: into Excel? Into a cell in the worksheet, into 
>a VBA variable?
>What code did you try? I never use blobs, but I don't think it should 
>be a problem.
>
>RBS
>
>
>
>On Fri, May 8, 2015 at 8:15 PM, Preston King  
>wrote:
>
> > Does anyone have an example of how to read sqlite blob records, that
> > are not pictures, into Excel? I have been trying to find some VBA code
> > to do this but am not having much luck. Thanks
> > ___
> > sqlite-users mailing list
> > sqlite-users at mailinglists.sqlite.org
> > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> >
>___
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>___
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
`--- 

[sqlite] VBA Sqllite blob data

[Simon Slavin]

On 11 May 2015, at 3:25pm, Jean-Christophe Deschamps  
wrote:

> Isn't that the actual size limit of Excel strings?

Sort of.  Although Excel cells can contain text longer than 255 characters, VBA 
functions ignore text parameters after the 255th character.  This is because 
VBA, when originally written, used Pascal-type strings internally.

Simon.

[sqlite] Please confirm what I THINK I know about blobs

[Drago, William @ CSG - NARDA-MITEQ]

> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Eduardo Morras
> Sent: Monday, May 11, 2015 11:02 AM
> To: sqlite-users at mailinglists.sqlite.org
> Subject: Re: [sqlite] Please confirm what I THINK I know about blobs
>
> On Mon, 11 May 2015 14:00:41 +
> "Drago, William @ CSG - NARDA-MITEQ"  wrote:
>
>
> > Correct me if I'm wrong, but the only way to read comments is by
> > reading back the entire CREATE TABLE string, correct?
>
> Yes, you need to parse it. You search for '--' and '\n'. The chars
> between them are the comment.
>
> I thought you need it only for documentation purpouse and not
> automatic/dynamic programming.


I should have included more information in my original post, but I'm always 
afraid of boring people with too much information.

--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com

CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] Please confirm what I THINK I know about blobs

[Drago, William @ CSG - NARDA-MITEQ]

All good suggestions, folks. To summarize:

Dr. Hipp uses an additional column.
Eduardo Morras recommends comments.
Simon Slavin recommends comments or in some cases a table dedicated to metadata.
Darren Duncan confirms the need for metadata.
Scott Doctor recommends putting the info in the column name.
Eric Hill suggests taking advantage of SQLite's type flexibility and adding the 
info to the column type.

I liked the idea of using comments, but while they are great for human 
consumption, they are not easy to read programmatically. Since I want to build 
VEE* structs automatically from SQLite tables this is important.

Correct me if I'm wrong, but the only way to read comments is by reading back 
the entire CREATE TABLE string, correct?

* http://en.wikipedia.org/wiki/Agilent_VEE

Thanks,
--
Bill Drago
Senior Engineer
L3 Narda-MITEQ
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / William.Drago at L-3COM.com


> -Original Message-
> From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-
> users-bounces at mailinglists.sqlite.org] On Behalf Of Eric Hill
> Sent: Saturday, May 09, 2015 9:55 PM
> To: General Discussion of SQLite Database
> Subject: Re: [sqlite] Please confirm what I THINK I know about blobs
>
> This approach:
>
> CREATE TABLE blob_table (
>   ModelNo TEXT,
>   SerialNo TEXT,
>   VSWR BLOB_DOUBLE
> )
>
> involves comments?  I don't see how.  Nothing wrong with the comments
> approach, but this is an approach that just takes advantage of the fact
> that SQLite does not have fixed data types.
>
> Eric
>
> From: Simon Slavin
> Sent: ?Saturday?, ?May? ?9?, ?2015 ?3?:?52? ?PM
> To: General Discussion of SQLite Database users at mailinglists.sqlite.org>
>
>
> On 9 May 2015, at 8:12pm, Drago, William @ CSG - NARDA-MITEQ
>  wrote:
>
> > Best idea yet! Anyone see any issues with this?
>
> It's actually a comment, and SQLite provides ways of putting proper
> comments in table definitions:
>
> CREATE TABLE blob_table (
>  ModelNo TEXT, -- new-style models as used from 2006 onwards  SerialNo
> TEXT,  VSWR BLOB -- array of ten double-length floats
> )
>
> These comments can be found if you look at the table definition in
> sqlite_master.
>
> I've also seen SQL databases where the designer created an otherwise
> unused table to hold comments on every column, something like this:
>
> CREATE TABLE _structure (
>  tableName TEXT,
>  columnName TEXT,
>  introduced TEXT,
>  variableType TEXT,
>  theComments TEXT
> )
>
> 'introduced' was the edit of their program which first used the column
> (equivalent to 'checkin' as used by the SQLite development team).
> 'variableType' was not the SQL type but the type of variable in the
> programming language they were using the database with.  This helped
> because the language had numerous variable types and subtle bugs could
> be introduced if you, for example, stored a value from an unsigned
> integer then did maths on the value in a long integer.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.

[sqlite] Bug: Cannot compile the new sqlite-src-3081001: preprocessor and testuite errors

[Jan Nijtmans]

2015-05-11 10:01 GMT+02:00 Jan Stan?k :
> 2) When I "fix" the previous error, I'm getting assertion failure
> during the test suite run.
...
> shell1-5.0...testfixture:
> /builddir/build/BUILD/tcl8.6.3/generic/tclIO.c:5815: DoReadChars:
> Assertion `!((statePtr)->flags & ((1<<9))) || ((statePtr)->flags &
> ((1<<10))) || Tcl_InputBuffered((Tcl_Cha
> nnel)chanPtr) == 0' failed.
>
> The testsuite error does not occur in the 3.9.* version.

Did the Tcl version get an upgrade in the mean time? Does the
problem still happen when running Tcl compiled from trunk?
There was a regression introduced in recent Tcl 8.6.x versions,
which will be fixed in (upcoming) version 8.6.5. So - in short -
I suspect that this assertion is not SQLite's fault but Tcl's ;-).

Regards,
   Jan Nijtmans

[sqlite] Issue: Inconsistency of sqlite3_dbstat_register declaration

[Jan Nijtmans]

2015-05-10 21:06 GMT+02:00 Roger Binns :
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> There is a forward declaration of sqlite3_dbstat_register (currently
> line 130871 in the 3.8.10.1 amalgamation):
>
>   int sqlite3_dbstat_register(sqlite3*);
>
> Later is the actual implementation (currently line 155838 in the
> 3.8.10.1 amalgamation):
>
>   SQLITE_API int SQLITE_STDCALL sqlite3_dbstat_register(sqlite3 *db){
>
> If SQLITE_API or SQLITE_STDCALL are set to anything then the
> inconsistency can cause a compiler error.  In my case SQLITE_API is
> defined as static.

The function sqlite3_dbstat_register() shouln't be an exported function
at all, I would suggest to rename it to sqlite3DbstatInit, that would
be consistent with other compiled-in extensions (e.g. sqlite3RtreeInit)
and it would fix the problem you are describing.

Worse: the tcl extension uses sqlite3_dbstat_register() when compiled
with -DSQLITE_ENABLE_DBSTAT_VTAB=1, which means that
1) Initialization of the dbstat extension will be done twice.
2) If sqlite is not compiled with -DSQLITE_ENABLE_DBSTAT_VTAB=1, or
the function is renamed (as it should) it wouldn't even work.

The latter part is already fixed in the TEA version of SQLite.
Suggested patch:


Regards,
 Jan Nijtmans

[sqlite] Bug: Cannot compile the new sqlite-src-3081001: preprocessor and testuite errors

[Jan Staněk]

Hello,
I'm trying to build sqlite from source (sqlite-src) for Fedora. In the
latest version (3.8.10.1), I encountered two issues that prevents me
from building it:

1) The compilation fails on file sqlite3_analyzer.c, with error

sqlite3_analyzer.c:14131:30: error: #if with no expression
 #if SQLITE_ENABLE_DBSTAT_VTAB

I found out that this is due to the way the macro is defined on the
very top of the file: `#define SQLITE_ENABLE_DBSTAT_VTAB`. As the
macro evaluates to nothing, the #if statement is invalid. Also, this
way effectively prevents me from using the macro as compile flag,
because this way overwrite any definition of this macro in compile flags.

Origin of the line is in the Makefile (Makefile.in), and it is added
during the sqlite3_analyzer.c creation in said Makefile.

2) When I "fix" the previous error, I'm getting assertion failure
during the test suite run.

The way I fixed the previous error:
#ifndef SQLITE_ENABLE_DBSTAT_VTAB
#define SQLITE_ENABLE_DBSTAT_VTAB 0
#endif

Then I add the `-DSQLITE_ENABLE_DBSTAT_VTAB=1` flag to the CFLAGS, and
the compilation sucessfully finishes. However, the testsuite run fails
with the following error:

shell1-5.0...testfixture:
/builddir/build/BUILD/tcl8.6.3/generic/tclIO.c:5815: DoReadChars:
Assertion `!((statePtr)->flags & ((1<<9))) || ((statePtr)->flags &
((1<<10))) || Tcl_InputBuffered((Tcl_Cha
nnel)chanPtr) == 0' failed.

The testsuite error does not occur in the 3.9.* version.

Best regards,
Jan
-- 
Jan Stanek - Red Hat Associate Developer Engineer - Databases Team

[sqlite] VBA Sqllite blob data

[Preston King]

I have a db3 config file that contains several different records. I need to 
select one specific record and store it in an excel worksheet cell. I have been 
able to create a routine to extract the information that I need once I get the 
record into a worksheet cell. The problem that I have run into is the record is 
longer than 255 characters and gets truncated at that limit.


-Original Message-
From: sqlite-users-bounces at mailinglists.sqlite.org 
[mailto:sqlite-users-boun...@mailinglists.sqlite.org] On Behalf Of Bart 
Smissaert
Sent: Friday, May 08, 2015 5:23 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] VBA Sqllite blob data

What do you mean with: into Excel? Into a cell in the worksheet, into a VBA 
variable?
What code did you try? I never use blobs, but I don't think it should be a 
problem.

RBS



On Fri, May 8, 2015 at 8:15 PM, Preston King  wrote:

> Does anyone have an example of how to read sqlite blob records, that 
> are not pictures, into Excel? I have been trying to find some VBA code 
> to do this but am not having much luck. Thanks 
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users at mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Is a transaction in progress?

[Florian Weimer]

On 05/11/2015 09:11 AM, Florian Weimer wrote:
> Is there a way to discover if a transaction is in progress for a given
> database handle, without committing or aborting the transaction?

Found it?it's sqlite3_get_autocommit.  The name is not really obvious,
though.

-- 
Florian Weimer / Red Hat Product Security

[sqlite] Is a transaction in progress?

[Florian Weimer]

Is there a way to discover if a transaction is in progress for a given
database handle, without committing or aborting the transaction?

-- 
Florian Weimer / Red Hat Product Security

[sqlite] Issue: Inconsistency of sqlite3_dbstat_register declaration

[Roger Binns]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 05/11/2015 01:34 AM, Jan Nijtmans wrote:
> 2) If sqlite is not compiled with -DSQLITE_ENABLE_DBSTAT_VTAB=1,
> or the function is renamed (as it should) it wouldn't even work.

That was my scenario.  I just -DSQLITE_ENABLE_DBSTAT_VTAB and the code
didn't compile because of the inconsistency.

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1

iEYEARECAAYFAlVQvbgACgkQmOOfHg372QQ2eACdHWNbxVjmDGbzFtktgwADzwnH
rckAnRn30JWtYfBHzY0j5qG8tV8Kb8YO
=LfCW
-END PGP SIGNATURE-