On Mon, 11 May 2015 22:24:53 +0300
wrote:
> 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.
Huh, somehow I'd forgotten that!
> Once the initial table is created by the fir
-- 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 & "' 'E
>-- 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
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 probl
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
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 cre
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
-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 sug
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 be
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 comm
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
>
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
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 informati
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 w
> -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 wha
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 n
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
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 (curre
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
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 int
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 Pro
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
-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
di
23 matches
Mail list logo