PrimalSQL and SQL query

Support for all customers who have purchased a PrimalSQL product license. This forum does not offer a response time guarantee.
Forum rules
DO NOT POST SUBSCRIPTION NUMBERS, LICENSE KEYS OR ANY OTHER LICENSING INFORMATION IN THIS FORUM.
Only the original author and our tech personnel can reply to a topic that is created in this forum. If you find a topic that relates to an issue you are having, please create a new topic and reference the other in your post.

Any code longer than three lines should be added as code using the 'Select Code' dropdown menu or attached as a file.
User avatar
rimvydukas
Posts: 2
Joined: Thu Mar 18, 2010 6:22 pm

PrimalSQL and SQL query

Post by rimvydukas » Thu Mar 18, 2010 6:22 pm

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.

User avatar
davidc
Posts: 5801
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL and SQL query

Post by davidc » Fri Mar 19, 2010 6:20 am

This is only supported in the SQL Document type. If you are using the Query Builder you will have to convert the document.



David
David
SAPIEN Technologies, Inc.

User avatar
rimvydukas
Posts: 2
Joined: Thu Mar 18, 2010 6:22 pm

PrimalSQL and SQL query

Post by rimvydukas » Sun Mar 21, 2010 4:52 pm

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

User avatar
davidc
Posts: 5801
Joined: Thu Aug 18, 2011 4:56 am

PrimalSQL and SQL query

Post by davidc » Mon Mar 22, 2010 2:17 am

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
David
SAPIEN Technologies, Inc.