Kirix Support Forums

SQL view

Please post any help questions, requests or other feedback here.

SQL view

Postby poison on Tue Aug 07, 2007 8:37 pm

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.
Registered User
Posts: 1
Joined: Tue Aug 07, 2007 8:27 pm

Re: SQL view

Postby Aaron on Wed Aug 08, 2007 11:18 am

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

Aaron Williams
Kirix Support Team
User avatar
Kirix Support Team
Posts: 120
Joined: Fri Dec 16, 2005 3:01 pm

Return to Strata Help & Feedback