SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Error on join completion - 3.0.23 beta

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Error on join completion - 3.0.23 beta
Author Message
maxpesola



Joined: 26 Nov 2007
Posts: 51

Post Error on join completion - 3.0.23 beta Reply with quote
On completion of inner join with the 3.0.23 beta , sqla wrong to put points on sql server 2005 (with db 2000):
Quote:
SELECT * FROM tabRMAItemInfos tri
INNER JOIN tabRMAItem tr ON trIDRMAItem = tri..IDRMAItem

Mon Nov 26, 2007 6:04 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
1. I am unable to reproduce it. Please describe which method you used to enter this JOIN. We need to know exact steps in order to reproduce it.

2. I am sorry, but I had to change your forum user name to something more acceptable. We do not support names with xxx suffixes for reasons, I am sure you well understand. If you want you can update your profile and change the suggested name to something else.


Thanks
Mon Nov 26, 2007 8:27 am View user's profile Send private message
maxpesola



Joined: 26 Nov 2007
Posts: 51

Post Reply with quote
No problem with the login that you have selected.
I hope this image clarifies:

you can see that error in the list , it's when i select any foreign keys on any tables after "ON" and a space.
My mssqls 2005 is up to date , the db is 2000 , i've winxpsp2 up to date.
I remember with 3.0.20 it's ok.
On the list , you can see another bug: strange trasparent rectangles with shadow appear randomly when you open the window of any store procedures with CTRL on their name, it's no easy to reproduce but it often happens, after the rectangles are visible into all the winxp windows, also now into IE (with the 2 version , they don't appear).
Mon Nov 26, 2007 9:17 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6509

Post Reply with quote
Thanks for the detailed info. We are looking into this. I'm not sure if a fix for the JOIN can make into today's build, but that should be something simple that we can fix soon. As for the weird boxes, the exact cause is not very clear. We are investigating this issue.
Mon Nov 26, 2007 11:38 am 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
Page 1 of 1

 
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.