Adobe AIR Development

[dmbproduction]

Hey guys,

I've been able to work with the .db file type using the SQLite commands in AS, however I now have a .sql file that I would like to read from. Is there anyway to read the .sql file? I'm currently getting  an error stating that this is not a valid database type.

If there isn't a way to read a file with a .sql extension, does anyone know of a way to convert it to the .db file type?

Thanks in advance,

[bdaemon]

.sql file normally means there are some SQL statment in the file , you can run the sql file at database console .

[dmbproduction]

what's database console? I've been using the firefox SQLite plug in to view my .sql file and it renders properly

[peter9477]

It's the "command shell" utility found in the downloads page: http://sqlite.org/download.html

Let's you open up a .db file and manipulate it using raw SQL commands, and some related tools. If the .sql file you have consists of raw SQL statements, it may have been built using this tool (assuming you didn't build it yourself), and it may be possible to feed it to this tool using something like the -init option.

[dmbproduction · Accepted solution]

Thanks Peter... What I ended up doing was open the SQLite file DB fille I had in RazorSQL which provided me with the SQLite commands, then using the comand line interface created a new <filename>.db file using the create table from the RazorSQL, once the new db file was create I then opened it using the free Firefox plug in and ran the rest of the SQL comands provided by RazorSQL to populate the table.