Error in reading sql output

asked 8 years ago

Dinosaver
990 ●1 ●7

updated 7 years ago

__AmirRoth__

4446 ●5 ●17 http://bleedinggreenna...

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?

Comments

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

rpg777 ( 8 years ago )

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

Dinosaver ( 8 years ago )

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

rpg777 ( 8 years ago )

link text

Dinosaver ( 8 years ago )

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

rpg777 ( 8 years ago )

see more comments

2 Answers

Sort by » oldest newest most voted

answered 8 years ago

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.

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 ( 8 years ago )

add a comment

answered 8 years ago

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

updated 8 years ago

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.