Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file

Jonathan Ryshpan <jonrysh -AT- pacbell.net>
Fri, 25 May 2012 07:16:44 -0700

I have been attempting to send this posting for a while, and have only
recently noticed that the list does not accept attachments.  This has
(apparently) caused it to be silently rejected.  I have appended what 
had been attached to the end of this posting.

Sorry for the delay.

On Mon, 2012-05-21 at 14:40 -0700, Jonathan Ryshpan wrote:

... the database doesn't look like what I had expected it to: sqlite
databases contain within themselves the names and data types of all
the entries, but when libreOffice opens the database, there is no such
data visible.  Am I missing something.  A dump of the database using 
"$ sqlite3 <archive>.sdb .dump" looks fine.  Is this what I should expect,
or is something wrong, or am I missing something? On Tue, 2012-05-22


On Tue, 22 May 2012 at 00:43 +0200, Andreas Säger wrote:

Am 21.05.2012 23:40, Jonathan Ryshpan wrote:


blah


Ask your question on a SQLite forum with some _technical_ information 
about your operating system, SQLite version of the creating application, 
driver version, configuration file, connection URL of the client (Base 
menu:Edit>Database>Properties).


Wow!  This is enough to singe my beard.  Nevertheless I am grateful for
all replies, even beard singeing ones.

I fear that I put in too much technical detail, rather than too little.
As you see, I am a complete newbie to LibreOffice base (oobase), and am
only trying to find out whether I have succeeded in getting oobase to
open my database properly.  I don't think a posting to an sqlite forum
would be useful, since this is really a question about oobase.  

If oobase has connected properly to the database, it is useless for my 
purpose and I will give up on it and do what needs done with a bunch of 
shell scripts. If oobase has not opened the database properly, I will 
persevere.

Here is the technical info that Mr. Säger desires:

All my systems run Fedora-16.  The database was generated on an i686
system.  LibreOffice runs on an x86_64 system.  The database is
contained in a file named wview-archive.sdb generated on the i686 
system and copied to the x86_64 system.

The database was generated by wview, which can be downloaded at
        http://www.wviewweather.com/
My running version of wview is accessible (in case you want to know
the weather here) at:
        http://oaklandweather.no-ip.org/index.html/
The archive file is not visible from the web, but extracts from it 
are at:
        http://oaklandweather.no-ip.org/index.html/Archive
The version of sqlite is included in 
        sqlite-devel-3.7.7.1-1.fc16.<......>.rpm
The library is:
        /usr/lib/libsqlite3.so.0.8.6
The drivers are in:
        unixODBC-2.2.14-13.fc15.x86_64
and as specified in its initialization file (which follows)
        $ cat ~/.odbc
        [ODBC Data Sources]
        mysqlitedb=SQLite

        [mysqlitedb]
        Driver=/usr/lib64/libsqlite3odbc.so
        Description=My SQLite test database
        Database=/home/jonrysh/src/wview/archive/nullWindSpeed/wview-archive.sdb
        # optional lock timeout in milliseconds
        Timeout=2000
The start of a dump of the database is appended to this message. 
I.e. the output of
        $ sqlite3 archive.sdb .dump

If anyone else wants to know more about my struggles with oobase and 
sqlite, email me or post to the list.

All the best - jon

======================= archive.txt =======================
PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE archive (
        dateTime INTEGER NOT NULL UNIQUE PRIMARY KEY,
        usUnits INTEGER NOT NULL,
        interval INTEGER NOT NULL,
        barometer REAL,
        pressure REAL,
        altimeter REAL,
        inTemp REAL,
        outTemp REAL,
        inHumidity REAL,
        outHumidity REAL,
        windSpeed REAL,
        windDir REAL,
        windGust REAL,
        windGustDir REAL,
        rainRate REAL,
        rain REAL,
        dewpoint REAL,
        windchill REAL,
        heatindex REAL,
        ET REAL,
        radiation REAL,
        UV REAL,
        extraTemp1 REAL,
        extraTemp2 REAL,
        extraTemp3 REAL,
        soilTemp1 REAL,
        soilTemp2 REAL,
        soilTemp3 REAL,
        soilTemp4 REAL,
        leafTemp1 REAL,
        leafTemp2 REAL,
        extraHumid1 REAL,
        extraHumid2 REAL,
        soilMoist1 REAL,
        soilMoist2 REAL,
        soilMoist3 REAL,
        soilMoist4 REAL,
        leafWet1 REAL,
        leafWet2 REAL,
        rxCheckPercent REAL,
        txBatteryStatus REAL,
        consBatteryVoltage REAL,
        hail REAL,
        hailRate REAL,
        heatingTemp REAL,
        heatingVoltage REAL,
        supplyVoltage REAL,
        referenceVoltage REAL,
        windBatteryStatus REAL,
        rainBatteryStatus REAL,
        outTempBatteryStatus REAL,
        inTempBatteryStatus REAL
);
INSERT INTO "archive" 
VALUES(1337285700,1,5,29.903,29.903,29.89414,70.099998,64.300003,47.0,64.0,NULL,NULL,0.0,NULL,0.0,0.0,51.855492,NULL,64.300003,0.0,947.0,8.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337286000,1,5,29.9,29.9,29.89114,70.199997,64.5,47.0,65.0,4.0,157.5,9.0,45.0,0.0,0.0,52.466148,64.5,64.5,0.0,946.0,8.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,0.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337286300,1,5,29.898001,28.888617,29.903215,70.099998,64.800003,48.0,64.0,3.0,157.5,10.0,67.5,0.0,0.0,52.328781,64.800003,64.800003,0.0,943.0,8.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337286600,1,5,29.9,28.8908,29.905462,70.199997,65.199997,48.0,63.0,3.0,270.0,8.0,112.5,0.0,0.0,52.278957,65.199997,65.199997,0.0,942.0,8.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337286900,1,5,29.898001,28.889185,29.903801,70.199997,66.0,48.0,62.0,2.0,112.5,5.0,90.0,0.0,0.0,52.598766,66.0,66.0,0.0,941.0,7.9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337287200,1,5,29.893,28.884844,29.899336,70.400002,66.300003,48.0,63.0,3.0,315.0,6.0,315.0,0.0,0.0,53.318062,66.300003,66.300003,0.0,942.0,7.9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337287500,1,5,29.893999,28.88623,29.900761,70.199997,66.900002,48.0,61.0,3.0,45.0,7.0,22.5,0.0,0.0,53.003407,66.900002,66.900002,0.0,939.0,7.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337287800,1,5,29.893,28.885727,29.900244,70.199997,67.0,48.0,60.0,3.0,337.5,6.0,292.5,0.0,0.0,52.647053,67.0,67.0,0.0,936.0,7.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337288100,1,5,29.892,28.885132,29.899632,70.400002,66.900002,48.0,61.0,3.0,157.5,7.0,22.5,0.0,0.0,53.003407,66.900002,66.900002,0.0,932.0,7.7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337288400,1,5,29.893,28.886364,29.9009,70.400002,67.0,49.0,58.0,3.0,112.5,7.0,112.5,0.0,0.0,51.726032,67.0,67.0,0.022,929.0,7.6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337288700,1,5,29.893,28.886597,29.901138,70.400002,67.099998,48.0,60.0,3.0,315.0,9.0,337.5,0.0,0.0,52.74094,67.099998,67.099998,0.0,926.0,7.5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337289000,1,5,29.893,28.886805,29.901352,70.400002,67.5,48.0,59.0,3.0,0.0,8.0,0.0,0.0,0.0,52.658451,67.5,67.5,0.0,918.0,7.4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337289300,1,5,29.889999,28.88414,29.898613,70.599998,67.5,48.0,57.0,3.0,337.5,6.0,337.5,0.0,0.0,51.721531,67.5,67.5,0.0,915.0,7.3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337289600,1,5,29.886999,28.881439,29.895834,70.599998,67.699997,48.0,60.0,3.0,112.5,7.0,112.5,0.0,0.0,53.304253,67.699997,67.699997,0.0,909.0,7.3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337289900,1,5,29.889999,28.884537,29.899019,70.599998,68.5,48.0,56.0,4.0,45.0,10.0,22.5,0.0,0.0,52.173141,68.5,68.5,0.0,903.0,7.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337290200,1,5,29.889999,28.884808,29.899298,70.699997,68.699997,48.0,55.0,3.0,45.0,8.0,337.5,0.0,0.0,51.869949,68.699997,68.699997,0.0,891.0,7.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337290500,1,5,29.889,28.884102,29.898571,70.699997,68.199997,48.0,55.0,4.0,67.5,10.0,45.0,0.0,0.0,51.405518,68.199997,68.199997,0.0,887.0,6.9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337290800,1,5,29.889,28.884275,29.898752,70.699997,67.400002,48.0,54.0,5.0,90.0,11.0,112.5,0.0,0.0,50.167797,67.400002,67.400002,0.0,881.0,6.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337291100,1,5,29.886,28.881449,29.895842,70.599998,66.599998,48.0,59.0,4.0,90.0,9.0,90.0,0.0,0.0,51.815159,66.599998,66.599998,0.0,874.0,6.7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337291400,1,5,29.888,28.883368,29.897818,70.599998,67.400002,48.0,57.0,3.0,67.5,8.0,67.5,0.0,0.0,51.628231,67.400002,67.400002,0.0,860.0,6.6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337291700,1,5,29.891001,28.886328,29.900862,70.699997,67.5,48.0,55.0,4.0,67.5,9.0,67.5,0.0,0.0,50.75526,67.5,67.5,0.0,854.0,6.4,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337292000,1,5,29.888,28.883493,29.897947,70.699997,67.199997,48.0,57.0,4.0,45.0,9.0,67.5,0.0,0.0,51.441616,67.199997,67.199997,0.021,844.0,6.3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337292300,1,5,29.886999,28.882559,29.896984,70.900002,67.099998,48.0,59.0,4.0,45.0,11.0,45.0,0.0,0.0,52.283669,67.099998,67.099998,0.0,837.0,6.2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337292600,1,5,29.886999,28.882582,29.897009,70.900002,67.0,48.0,55.0,5.0,90.0,9.0,112.5,0.0,0.0,50.290749,67.0,67.0,0.0,827.0,6.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337292900,1,5,29.886999,28.882595,29.897022,71.099998,66.300003,47.0,58.0,4.0,67.5,11.0,67.5,0.0,0.0,51.071461,66.300003,66.300003,0.0,820.0,5.9,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337293200,1,5,29.884001,28.879656,29.893999,71.099998,65.699997,47.0,57.0,6.0,90.0,11.0,90.0,0.0,0.0,50.041874,65.699997,65.699997,0.0,807.0,5.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337293500,1,5,29.884001,28.879574,29.893915,70.900002,65.599998,47.0,58.0,6.0,90.0,11.0,112.5,0.0,0.0,50.416821,65.599998,65.599998,0.0,799.0,5.6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337293800,1,5,29.882999,28.878525,29.892836,70.900002,65.699997,47.0,59.0,5.0,45.0,10.0,90.0,0.0,0.0,50.971767,65.699997,65.699997,0.0,787.0,5.5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337294100,1,5,29.881001,28.876524,29.890778,70.900002,65.400002,47.0,57.0,4.0,90.0,10.0,90.0,0.0,0.0,49.761894,65.400002,65.400002,0.0,779.0,5.3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337294400,1,5,29.879,28.874506,29.8887,71.099998,65.400002,47.0,60.0,3.0,90.0,9.0,90.0,0.0,0.0,51.144642,65.400002,65.400002,0.0,765.0,5.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337294700,1,5,29.874001,28.869596,29.883652,71.099998,66.099998,47.0,61.0,2.0,225.0,6.0,90.0,0.0,0.0,52.250721,66.099998,66.099998,0.0,754.0,5.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337295000,1,5,29.872999,28.868597,29.882624,71.199997,66.900002,47.0,55.0,3.0,22.5,7.0,0.0,0.0,0.0,50.197842,66.900002,66.900002,0.0,747.0,4.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337295300,1,5,29.874001,28.869583,29.883638,71.400002,67.199997,47.0,58.0,3.0,0.0,6.0,22.5,0.0,0.0,51.913036,67.199997,67.199997,0.0,734.0,4.7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337295600,1,5,29.872,28.867683,29.881683,71.599998,67.5,47.0,56.0,2.0,22.5,7.0,0.0,0.0,0.0,51.242188,67.5,67.5,0.019,720.0,4.5,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337295900,1,5,29.870001,28.865801,29.879749,71.800003,68.099998,47.0,54.0,3.0,67.5,6.0,90.0,0.0,0.0,50.816624,68.099998,68.099998,0.0,711.0,4.3,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337296200,1,5,29.868999,28.86491,29.878832,71.900002,68.300003,47.0,53.0,3.0,45.0,7.0,67.5,0.0,0.0,50.497425,68.300003,68.300003,0.0,697.0,4.1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337296500,1,5,29.868,28.864027,29.877922,72.099998,68.5,46.0,54.0,3.0,45.0,5.0,67.5,0.0,0.0,51.187351,68.5,68.5,0.0,681.0,4.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337296800,1,5,29.868,28.864117,29.878016,72.300003,68.5,46.0,54.0,3.0,45.0,9.0,22.5,0.0,0.0,51.187351,68.5,68.5,0.0,669.0,3.8,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337297100,1,5,29.868999,28.865168,29.879097,72.400002,67.900002,46.0,52.0,4.0,90.0,11.0,67.5,0.0,0.0,49.615364,67.900002,67.900002,0.0,658.0,3.7,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
INSERT INTO "archive" 
VALUES(1337297400,1,5,29.864,28.860388,29.87418,72.400002,67.099998,46.0,53.0,6.0,90.0,11.0,90.0,0.0,0.0,49.387642,67.099998,67.099998,0.0,649.0,3.6,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0.0,0.0,799.0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
COMMIT;




-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted

Context

[libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Jonathan Ryshpan
- Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Mirosław Zalewski
  - Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Jonathan Ryshpan
    - Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Jonathan Ryshpan
      - [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · Andreas Säger
        
        Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Jonathan Ryshpan
        
        [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · Alexander Thurgood
        
        Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Joep L. Blom
        
        [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · NoOp
        
        [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · NoOp
        [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · NoOp
    - Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Tom Davies
      - Re: [libreoffice-users] Connecting libreoffice calc to existing sqlite database file · Simon Cropper
    - [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · Alexander Thurgood
- [libreoffice-users] Re: Connecting libreoffice calc to existing sqlite database file · Andreas Säger

Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.