Error in reading sql output

asked 2016-05-27 10:17:40 -0600

Dinosaver
990 ●1 ●7

updated 2017-05-08 18:21:42 -0600

E+ provides the results in .sql format for SQLite 3 database. But when I try to launch this sql to get a real database in .sqlite format it returns me a syntax error. Just opening works fine, but I need to process data further, so I'd like to have a real database... What may be the problem?

edit retag flag offensive close merge delete

Comments

I think we need some more information, here. Could you share your command statements and any standard or error messages returned?

rpg777 ( 2016-05-27 16:53:23 -0600 )edit

I use DB Browser for SQLite (the same with some others). The message is "Error in statement #1: near "SQLite": syntax error

Dinosaver ( 2016-05-28 10:20:39 -0600 )edit

Hmmm, can you put a copy of the DB on Dropbox or similar, and provide a download link?

rpg777 ( 2016-06-01 09:49:02 -0600 )edit

link text

Dinosaver ( 2016-06-03 13:15:42 -0600 )edit

This file opens fine in OpenStudio's ResultsViewer app, and SQLite Browser.

rpg777 ( 2016-06-03 16:29:42 -0600 )edit

see more comments

2 Answers

Sort by » oldest newest most voted

answered 2016-06-04 04:13:10 -0600

Yi Zhang
1250 ●11 ●6

The eplustbl.sql file is a SQLite database. It is not a SQL command file. So you should open it in DB browser and then do queries using your own SQL command.

edit flag offensive delete link

Comments

Ok, I got it. I just open it in DB Browser, dump to and .sql and then import that dump into an empty database with .db extension. Now it works. Thx everyone.

Dinosaver ( 2016-06-10 09:30:02 -0600 )edit

add a comment

answered 2016-06-06 14:31:09 -0600

rpg777
6970 ●6 ●15 http://openstudio.net/

updated 2016-06-06 17:39:57 -0600

Sorry, I misunderstood your question initially. Just putting your conundrum into the Googleizer, I found a few UOIs (urls of interest) that may help, here, here, and here. YMMV.