SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[9.0.157 BETA] Join suggestions missing?
Goto page 1, 2, 3  Next
 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[9.0.157 BETA] Join suggestions missing?
Author Message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post [9.0.157 BETA] Join suggestions missing? Reply with quote
I just updated since I see we are nearing the beta period so I figured it was bug free/stable enough.

In testing I am not getting join suggestions like normal?

Previously if I typed out:

"select runno from analrun as ar
inner join analrunseq as ars
on" and hit space.

it would suggest ars.RunNo = ar.RunNo.

Now I get no suggestions?


Thu Oct 06, 2016 3:36 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
Resetting the config did nothing for this.
Thu Oct 06, 2016 3:39 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
Which database server version is that?
Target environment version?
Thu Oct 06, 2016 3:44 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
Which database server version is that?
Target environment version?


Microsoft SQL Server 2008 (SP3) - 10.0.5841.0 (X64) May 25 2013 08:45:39 Copyright (c) 1988-2008 Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.0 <X64> (Build 6002: Service Pack 2) (VM)

Target Environment is the 64 bit SQL Editor that comes with SQL Assistant 9. But it also doesn't have the joins in SSMS which is: Microsoft SQL Server Management Studio 10.50.4042.0 (32 bit)
Thu Oct 06, 2016 3:45 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
I'm unable to reproduce your results.

Please try importing factory default configuration.
Try a different database to see if it's database or schema specific.
Thu Oct 06, 2016 3:54 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
I'm unable to reproduce your results.

Please try importing factory default configuration.
Try a different database to see if it's database or schema specific.


I did reset factory (see post 2)
Thu Oct 06, 2016 3:55 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
Tried another database (that I am not super familiar with or anything) but also did not get join suggestions.
Thu Oct 06, 2016 4:00 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
Hmm.. Not sure what else to suggest. Maybe a restart would help, clear some caches.

To the best of my knowledge nothing changed in that area.
Thu Oct 06, 2016 4:11 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
Hmm.. Not sure what else to suggest. Maybe a restart would help, clear some caches.

To the best of my knowledge nothing changed in that area.


Ok, I've:

Uninstalled

Restarted

Deleted %APPDATA%\SQL Assistant*

Deleted C:\ProgramData\SQL Assistant*

restarted again

re-loaded sql assistant with defaults.

no join suggestions.
Thu Oct 06, 2016 4:14 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
Hmm.. Not sure what else to suggest. Maybe a restart would help, clear some caches.

To the best of my knowledge nothing changed in that area.


A couple things changed when I compare the MSSQL Joins from 7.x and 9.x, but nothing major.

I'm at a loss here...
Thu Oct 06, 2016 4:42 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6505

Post Reply with quote
There are still couple of things that could be checked.
Please check SqlAssist.log file under %APPDATA%\SQL Assistant\9.0 that there ate no exceptions logged.

Validate Joins (MSSQL) query in the Options -> DB Options -> DB Queries. It should return some results if you replace :OBJECT_ID with id of your table with foreign keys.
Thu Oct 06, 2016 4:43 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
There are still couple of things that could be checked.
Please check SqlAssist.log file under %APPDATA%\SQL Assistant\9.0 that there ate no exceptions logged.

Validate Joins (MSSQL) query in the Options -> DB Options -> DB Queries. It should return some results if you replace :OBJECT_ID with id of your table with foreign keys.


this is literally the only thing that changed according to BC4.


Thu Oct 06, 2016 4:45 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
SysOp wrote:
There are still couple of things that could be checked.
Please check SqlAssist.log file under %APPDATA%\SQL Assistant\9.0 that there ate no exceptions logged.

Validate Joins (MSSQL) query in the Options -> DB Options -> DB Queries. It should return some results if you replace :OBJECT_ID with id of your table with foreign keys.


Hrmm. Ok nothing with the word 'exception' in it in the log.

But the second part... might be bingo. But why would it work before?

I inherited this DB from previous developers, it was grown from an Access Front end.

Referential integrity was done at that time via triggers, there are NO Foreign Keys in the database unless I have added them (and I don't think I've added any/many to avoid confusion).

So the question becomes is why did it work before? It used to join on fields with the same name, or like Data Types at the very least.
Thu Oct 06, 2016 4:48 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
Here's a screenshot I have from way back with SQL Assistant 6.4



So it did work, previously without PK/FK relationships.
Thu Oct 06, 2016 4:54 pm View user's profile Send private message
Mindflux



Joined: 25 May 2013
Posts: 616
Country: United States

Post Reply with quote
The 9.x help mentions:

In addition to using referential integrity definitions for JOIN clause suggestions, SQL Assistant can use columnname matches.
SQL Assistant uses color-coded styles to distinguish between different suggestion types.
Thu Oct 06, 2016 4:56 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Goto page 1, 2, 3  Next
Page 1 of 3

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.