Question-and-Answer Resource for the Building Energy Modeling Community
Get started with the Help page
Ask Your Question

Error in reading sql output

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

Dinosaver gravatar image

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


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

rpg777 gravatar image 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 gravatar image 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 gravatar image rpg777  ( 2016-06-01 09:49:02 -0600 )edit
Dinosaver gravatar image Dinosaver  ( 2016-06-03 13:15:42 -0600 )edit

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

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

2 Answers

Sort by ยป oldest newest most voted

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

Yi Zhang gravatar image

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 more


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 gravatar image Dinosaver  ( 2016-06-10 09:30:02 -0600 )edit

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

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.

edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account.

Add Answer

Training Workshops

Question Tools

1 follower


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

Seen: 470 times

Last updated: Jun 06 '16