SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Table name aliasing for DELETE within BEGIN END

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Table name aliasing for DELETE within BEGIN END
Author Message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Table name aliasing for DELETE within BEGIN END Reply with quote
v 5.0.74


Code:
BEGIN
  Delete
  From dbo.
END


If at the above point you specify a table, the table name is aliased (which is bad for a delete). This doesn't happen if it is outside of the BEGIN END (this is the desired behavior).

Also, with Delete From dbo.Table the SQL syntax helper then pops up FROM again. This one isn't a big deal, just FYI.
Fri Mar 26, 2010 9:00 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Thank you. I am able to reproduce this issue. If a DELETE statement is enclosed in BEGIN...END structure and FROM appears on a second line below DELETE, then an alias is inserted after the table name. I am going to submit this case.
Fri Mar 26, 2010 9:29 am View user's profile Send private message
judahr



Joined: 09 Mar 2007
Posts: 319
Country: United States

Post Additional Case Reply with quote
Code:

Delete
From dbo.Table1
where Column1 = @Column1


If you go up and remove dbo.Table1, then choose a different table, the table name will alias.
Wed Mar 31, 2010 11:32 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7849

Post Reply with quote
Thank you. We have already developed a fix for this issue. It should be available in the next beta version build. That build is not yet available for beta download. We are still hammering some other issues.
Wed Mar 31, 2010 12:44 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
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.