[OT] Table Creation Syntax + Visual SQL Query Builder // A GREAT Mac Cocoa MYSQL tool - Donationware
bobs at twft.com
Thu Jan 6 14:04:43 EST 2011
For sqLite I do something like this (keeping in mind I use sqlYoga):
put dbconn_get("connection id", "secconn", "secondary") into theSecID -- sqlYoga
put "SELECT tbl_name,sql FROM sqlite_master WHERE type = table" \
replace "tbl_name" with quote & "tbl_name" & quote in theSQL
replace "sql " with quote & "sql" & quote & space in theSQL
replace "table" with quote & "table" & quote in theSQL
put revDataFromQuery(comma, return, theSecID, theSQL) into theSQLData
This will give me all the Create Table syntax for every table in the sqLite database I access.
On Jan 5, 2011, at 1:50 PM, Ruslan Zasukhin wrote:
> On 1/5/11 10:57 PM, "Bob Sneidar" <bobs at twft.com> wrote:
> Hi Bob,
> Do you mean that you create table using GUI dialog,
> Then you can see SQL CREATE TABLE command?
> Well, actually mySQL itself can do this:
> SHOW CREATE TABLE command, can produce SQL command for any existed table
> Valentina db, also can do this.
> But now I think (if you underline this) -- we can easy add such feature to
> our SqlLite plugin in Valentina Studio ...
> SqlLite itself do not have such feature, but as I know we already have such
> code in plugin ... Just we can open this to contextual-menu command I think.
> BTW2. In Valentina Studio we have cool Visual Query Builder.
> It can help produce complex SQL queries by mouse clicks only.
> And good news are that Query Builder already works for SQLite also.
> Enjoy. :-)
>> Hey nice and it doesn't crash like the old MySQL Tools used to! I especially
>> love the "table creation syntax" which is useful for me when developing, since
>> I am not all that proficient at sql syntax.
> Best regards,
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
> Valentina - Joining Worlds of Information
> [I feel the need: the need for speed]
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode