SQL view

[poison]

Hi =)
Is there a SQL view hidden somewhere for Queries?
The popup when executing a query in design view certainly suggests it can handle SQL. I need too long and find it too complicated clicking queries together.

[Aaron]

Currently, the query builder doesn't have a SQL view, although we hope to add this. That said, if you prefer to type in queries directly, you can construct scripts that contain embedded SQL. We'll be posting comprehensive documentation for Strata's API in the next few days, but here's a quick example to get you going:

// example SQL script

// input and output paths; note: replace "input" and "output"
// with the appropriate paths in the project
var input = "input";
var output = "output";

// create a new database connection; note: DbConnection takes
// a connection string, so it can be used to connect to other
// databases, such as MySQL Enterprise; if no parameters are
// specified, it connects to the local project
var db = new DbConnection;

// construct a SQL statement to copy the input to the output
var sql = "SELECT * INTO TABLE " + output + " FROM " + input;

// execute the SQL statement
var iter = db.execute(sql);

// refresh the project
HostApp.refresh();

#139