Crank SQL

[Mike Kerner]

SWEET!

On Wed, Oct 22, 2014 at 12:41 PM, Sergey Pashkov <
sergey_pashkov at valentina-db.com> wrote:

> Hello, Mike
>
> I think, there are already a few ways to do it in Valentina Studio:
>
> 1) If your modifications are related, for example, to one table and its
> child objects, you can call "Design Table" dialog from a contextual menu.
> It has "SQL Preview" tab with generated queries. Link and view objects
> have such dialogs, too;
>
> 2) You can create a diagram and make your changes there. At any time, you
> can view generated queries for these changes and copy them;
>
> 3) Valentina Studio has a "Query Log" tool, there you can find all
> executed statements.
>
> --
> Best regards,
> Sergey Pashkov.
>
> On Wed, Oct 22, 2014 at 5:51 PM, Mike Kerner <MikeKerner at roadrunner.com>
> wrote:
>
>> Something else that would be cool for valentina to do is to generate the
>> SQL that I would need to make something happen so that I can embed it in
>> whatever app I'm developing.
>>
>> For example, let's say I want to change the datatype of a column in
>> sqlite.  You can't really do that, but Valentina works around it.  When
>> I want to make that happen in my app, I have to crank the SQL.  Generally
>> I do that by telling Valentina to create an SQL dump of before and after
>> (so I can create the temporary table, then copy the data, then drop the
>> original table, then recreate it, then copy the data back).  If Valentina
>> wrote the SQL for me...
>>
>> I can come up with a variety of other examples where it would be nice to
>> be able to walk Valentina through a sequence of operations, and have it
>> give me the SQL to copy/paste.
>>
>> --
>> On the first day, God created the heavens and the Earth
>> On the second day, God created the oceans.
>> On the third day, God put the animals on hold for a few hours,
>>    and did a little diving.
>> And God said, "This is good."
>>
>> _______________________________________________
>> Valentina mailing list
>> Valentina at lists.macserve.net
>> http://lists.macserve.net/mailman/listinfo/valentina
>>
>>
>
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>
>


-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20141022/12a9096a/attachment.html>