No text showing in SQL edit window when opening query

This forum can be browsed by the general public. Posting is limited to current SAPIEN license holders with active maintenance and does not offer a response time guarantee.
Forum rules
DO NOT POST LICENSE NUMBERS, ACTIVATION 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.
This topic is 9 years and 3 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.
User avatar
kevinwornell
Posts: 12
Last visit: Thu Apr 12, 2018 2:26 pm

No text showing in SQL edit window when opening query

Post by kevinwornell »

I am seeing an issue where I open a query and nothing shows on the screen. If I look at the file using notepad the query is in the file, however the editor does not display it.

In addition the Editor treats the previously saved query as a new file and prompts to save on exit, which is a very bad thing as then there really is nothing in the file.

This has been getting continuously worse over the last 3 or 4 updates to the program and is now at the point where every query I open shows as blank.

There are some other anomalies happening when I paste a known good query into the editor it does not show the tables or the links even thought it will run the query.

I am on Windows 8.1 - 64 bit, Primal SQL 4.0.37 64 bit.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: No text showing in SQL edit window when opening query

Post by davidc »

1. Please zip and email the file to support@sapien.com and we will take a look at it.

2. As for the save issue, please include a step by step process on how to recreate the issue.

3. Do you mean that the Query Builder is not showing the tables?

David
David
SAPIEN Technologies, Inc.
User avatar
kevinwornell
Posts: 12
Last visit: Thu Apr 12, 2018 2:26 pm

Re: No text showing in SQL edit window when opening query

Post by kevinwornell »

1. File is being emailed now.

2. a. I open what should be a good query by browsing to it then clicking on Open
b. The query window opens with nothing showing. Sometimes the text will show for a split second and then disappear. Usually though it is just no text, no tables
c. The Tab for the window shows the Asterisk indicating it needs to be saved
d. If I save it the file will be empty.

3. Yes this means no table show in the visual query builder window
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: No text showing in SQL edit window when opening query

Post by davidc »

Did you originally create this query using the Visual Query Builder?

When I open the file I get the following parser error:

Packages referenced by O365 task Sequence.query: Invalid SELECT statement.
Unexpected token "+" at line 2, pos 63


For now, I recommend changing the file extension to .sql and see if you can run the query using PrimalSQL but without using the designer.

We will also try to prevent the query builder from clearing out the text when it fails to parse the query.

David
David
SAPIEN Technologies, Inc.
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: No text showing in SQL edit window when opening query

Post by davidc »

I believe it has the wrong dialect setting.
I found that if you go to the query builder properties:

Ribbon->Home->Query->Query Builder Properties

And set the Dialect to Auto Detect:
Query Builder Properties.png
Query Builder Properties.png (37.15 KiB) Viewed 10757 times
It then displays the tables correctly.

What type of database are you connecting to?

David
David
SAPIEN Technologies, Inc.
User avatar
kevinwornell
Posts: 12
Last visit: Thu Apr 12, 2018 2:26 pm

Re: No text showing in SQL edit window when opening query

Post by kevinwornell »

The dialect is set to SQL 2008 which corresponds with the database. The query runs in SQL without issue and returns the desired results.
User avatar
kevinwornell
Posts: 12
Last visit: Thu Apr 12, 2018 2:26 pm

Re: No text showing in SQL edit window when opening query

Post by kevinwornell »

Is there a workaround for the screen clearing issue when syntax errors are detected? This is causing me a lot of issues at this time. Is there an earlier version that does not do this perhaps?
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: No text showing in SQL edit window when opening query

Post by davidc »

We are releasing the build this week. I will update you once it is released.

David
David
SAPIEN Technologies, Inc.
User avatar
kevinwornell
Posts: 12
Last visit: Thu Apr 12, 2018 2:26 pm

Re: No text showing in SQL edit window when opening query

Post by kevinwornell »

Thank you
User avatar
davidc
Posts: 5913
Last visit: Mon Jul 08, 2019 8:55 am
Been upvoted: 2 times

Re: No text showing in SQL edit window when opening query

Post by davidc »

The new build is now available. Please give it a try and let us know if you continue to encounter the issue with the disappearing query.

David
David
SAPIEN Technologies, Inc.
This topic is 9 years and 3 months old and has exceeded the time allowed for comments. Please begin a new topic or use the search feature to find a similar but newer topic.