 |
SoftTree Technologies
Technical Support Forums
|
|
Author |
Message |
maxpesola
Joined: 26 Nov 2007 Posts: 51
|
|
Error on join completion - 3.0.23 beta |
|
On completion of inner join with the 3.0.23 beta , sqla wrong to put points on sql server 2005 (with db 2000):
 |
 |
SELECT * FROM tabRMAItemInfos tri
INNER JOIN tabRMAItem tr ON trIDRMAItem = tri..IDRMAItem |
|
|
Mon Nov 26, 2007 6:04 am |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
maxpesola
Joined: 26 Nov 2007 Posts: 51
|
|
|
|
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 |
|
 |
SysOp
Site Admin
Joined: 26 Nov 2006 Posts: 7948
|
|
|
|
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 |
|
 |
|
|
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
|
|
|