Page 1 of 1

PrimalSQL and SQL query

Posted: Thu Mar 18, 2010 6:22 pm
by rimvydukas
Hi,Using latest version of product. I'm trying to write sql queries in "SQL edit" window. So my question is very simple - how can I run only selected part of query? I can do that in sql manager without any problems but I have not found the way how can I do this in primalsql:( Thanks.

PrimalSQL and SQL query

Posted: Fri Mar 19, 2010 6:20 am
by davidc
This is only supported in the SQL Document type. If you are using the Query Builder you will have to convert the document.



David

PrimalSQL and SQL query

Posted: Sun Mar 21, 2010 4:52 pm
by rimvydukas
Can you clarify what is this "SQL document type"? Where can I find it?

And are you going to add this support to query builder? It would be very nice to have such option in sql edit window.rimvydukas2010-03-21 23:58:38

PrimalSQL and SQL query

Posted: Mon Mar 22, 2010 2:17 am
by davidc
You can create a SQL Document by going to Main Application Button->New->New SQL Document.
Alternatively you can right click on a Connect in the Database Browser and select the "Query Database (SQL Only) option.

You can also convert your Query file to SQL file by using "Save As" button.


The query builder only supports a single statement. Therefore if you have multiple statements and you modified the Query builder, they will be replaced with the first statement.

David