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" \
into theSQL
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.
Bob
On Jan 5, 2011, at 1:50 PM, Ruslan Zasukhin wrote:
> On 1/5/11 10:57 PM, "Bob Sneidar" <b...@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.
>>
>> Bob
>
> --
> Best regards,
>
> Ruslan Zasukhin
> VP Engineering and New Technology
> Paradigma Software, Inc
>
> Valentina - Joining Worlds of Information
> http://www.paradigmasoft.com
>
> [I feel the need: the need for speed]
>
>
>
> _______________________________________________
> use-livecode mailing list
> use-livecode@lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription
> preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
_______________________________________________
use-livecode mailing list
use-livecode@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
