Sqlite

[Tobias Pankrath via Digitalmars-d-learn]

On Sunday, 11 January 2015 at 20:30:41 UTC, Paul wrote:
> On Sunday, 11 January 2015 at 20:20:21 UTC, ketmar via 
> Digitalmars-d-learn wrote:
>> note the single quotes in your code: that is where it all goes 
>> wrong. i
>> don't know where you got that quotes from, but this is not a 
>> valid SQL
>> syntax for `CREATE TABLE`. ;-)
>
> Thank you, I thought it might be something obvious - that will 
> teach me to cut and paste code! :D

Hint: Put the SQL in a file create_people.sql and import it into 
your code via the import statement:

string sql = import("create_people.sql"); // you'll need a 
correct -J compiler switch

That way you can easily test if it's correct on the commandline. 
It's .read <filename> in the sqlite3 shell.