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 -0500

Dinosaver's avatar

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

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's avatar rpg777  ( 2016-05-27 16:53:23 -0500 )edit

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

Dinosaver's avatar Dinosaver  ( 2016-05-28 10:20:39 -0500 )edit

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

rpg777's avatar rpg777  ( 2016-06-01 09:49:02 -0500 )edit
Dinosaver's avatar Dinosaver  ( 2016-06-03 13:15:42 -0500 )edit

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

rpg777's avatar rpg777  ( 2016-06-03 16:29:42 -0500 )edit

2 Answers

Sort by ยป oldest newest most voted

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

Yi Zhang's avatar

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's avatar Dinosaver  ( 2016-06-10 09:30:02 -0500 )edit

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

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

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

Question Tools

1 follower


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

Seen: 537 times

Last updated: Jun 06 '16