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.
No text showing in SQL edit window when opening query
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.
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.
- kevinwornell
- Posts: 12
- Last visit: Thu Apr 12, 2018 2:26 pm
Re: No text showing in SQL edit window when opening query
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
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.
SAPIEN Technologies, Inc.
- kevinwornell
- Posts: 12
- Last visit: Thu Apr 12, 2018 2:26 pm
Re: No text showing in SQL edit window when opening query
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
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
Re: No text showing in SQL edit window when opening query
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
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.
SAPIEN Technologies, Inc.
Re: No text showing in SQL edit window when opening query
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:
It then displays the tables correctly.
What type of database are you connecting to?
David
I found that if you go to the query builder properties:
Ribbon->Home->Query->Query Builder Properties
And set the Dialect to Auto Detect:
It then displays the tables correctly.
What type of database are you connecting to?
David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- kevinwornell
- Posts: 12
- Last visit: Thu Apr 12, 2018 2:26 pm
Re: No text showing in SQL edit window when opening query
The dialect is set to SQL 2008 which corresponds with the database. The query runs in SQL without issue and returns the desired results.
- kevinwornell
- Posts: 12
- Last visit: Thu Apr 12, 2018 2:26 pm
Re: No text showing in SQL edit window when opening query
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?
Re: No text showing in SQL edit window when opening query
We are releasing the build this week. I will update you once it is released.
David
David
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.
- kevinwornell
- Posts: 12
- Last visit: Thu Apr 12, 2018 2:26 pm
Re: No text showing in SQL edit window when opening query
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
David
SAPIEN Technologies, Inc.
SAPIEN Technologies, Inc.