Page 1 of 2

No text showing in SQL edit window when opening query

Posted: Mon Nov 24, 2014 1:27 pm
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.

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

Posted: Mon Nov 24, 2014 2:47 pm
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

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

Posted: Tue Nov 25, 2014 11:13 am
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

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

Posted: Wed Nov 26, 2014 10:22 am
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

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

Posted: Wed Nov 26, 2014 10:40 am
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 6863 times
It then displays the tables correctly.

What type of database are you connecting to?

David

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

Posted: Wed Nov 26, 2014 11:10 am
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.

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

Posted: Tue Dec 02, 2014 1:03 pm
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?

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

Posted: Tue Dec 02, 2014 3:25 pm
by davidc
We are releasing the build this week. I will update you once it is released.

David

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

Posted: Tue Dec 02, 2014 3:32 pm
by kevinwornell
Thank you

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

Posted: Wed Dec 03, 2014 11:01 am
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