SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
SA: 12.3.427 Drilling down non "+"-able breaks pic

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
SA: 12.3.427 Drilling down non "+"-able breaks pic
Author Message
Mindflux



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

Post SA: 12.3.427 Drilling down non "+"-able breaks pic Reply with quote
https://www.screencast.com/t/Y4c0u1IE9ol

Pressing the right arrow on non-drillable objects (so far, it seems like maybe just triggers) in the picker causes the picker window to get weird, backing up (left) once does weird things, but backing up twice at least brings you back to the objects.
Fri May 05, 2023 11:57 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Thank you very much for letting us know. We will investigate this weird effect
Fri May 05, 2023 2:01 pm View user's profile Send private message
Mindflux



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

Post Reply with quote
SysOp wrote:
Thank you very much for letting us know. We will investigate this weird effect


This does this for schema's too.
Fri May 05, 2023 3:20 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
So far we are unable to reproduce it with regular popups. Right arrow inserts selected trigger name into the editor.

If this is triggered from a code snippet, can you please share the snippet code?
Mon May 08, 2023 8:32 am View user's profile Send private message
Mindflux



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

Post Reply with quote
Code:
DISABLE TRIGGER $OBJECT(trigger, ins_object)$ ON $$ SELECT t.NAME FROM sys.tables AS t INNER JOIN sys.triggers AS t2 ON t2.parent_id = t.object_id WHERE t2.name = '$OBJECT(trigger, ins_object)$' $$
GO
|
ENABLE TRIGGER $OBJECT(trigger, ins_object)$ ON $$ SELECT t.NAME FROM sys.tables AS t INNER JOIN sys.triggers AS t2 ON t2.parent_id = t.object_id WHERE t2.name = '$OBJECT(trigger, ins_object)$' $$
GO


the snippet is called "trig".. so I invoke that to get the trigger name picker and hitting right once breaks the picker, then left once changes the picker view in some way, then left again back to trigger names.
Mon May 08, 2023 8:37 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
Thank you
Mon May 08, 2023 8:46 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.