Support Forums

No text showing in SQL edit window when opening query

Product support for PrimalSQL users
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.
User avatar
kevinwornell
Posts: 12
Joined: Sun Mar 03, 2013 12:43 pm

No text showing in SQL edit window when opening query

Postby kevinwornell » Mon Nov 24, 2014 1:27 pm

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

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

Postby davidc » Mon Nov 24, 2014 2:47 pm

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
Joined: Sun Mar 03, 2013 12:43 pm

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

Postby kevinwornell » Tue Nov 25, 2014 11:13 am

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

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

Postby davidc » Wed Nov 26, 2014 10:22 am

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

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

Postby davidc » Wed Nov 26, 2014 10:40 am

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 3950 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
Joined: Sun Mar 03, 2013 12:43 pm

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

Postby kevinwornell » Wed Nov 26, 2014 11:10 am

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
Joined: Sun Mar 03, 2013 12:43 pm

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

Postby kevinwornell » Tue Dec 02, 2014 1:03 pm

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: 4354
Joined: Thu Aug 18, 2011 4:56 am

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

Postby davidc » Tue Dec 02, 2014 3:25 pm

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
Joined: Sun Mar 03, 2013 12:43 pm

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

Postby kevinwornell » Tue Dec 02, 2014 3:32 pm

Thank you
User avatar
davidc
Posts: 4354
Joined: Thu Aug 18, 2011 4:56 am

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

Postby davidc » Wed Dec 03, 2014 11:01 am

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.

Return to “PrimalSQL”

Who is online

Users browsing this forum: No registered users and 1 guest

cron