Crank SQL

[Sergey Pashkov]

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
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20141022/ab7fadf0/attachment.html>