SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[12.0.171 BETA] - Auto Expand Placeholders

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[12.0.171 BETA] - Auto Expand Placeholders
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [12.0.171 BETA] - Auto Expand Placeholders Reply with quote
The tooltip for Auto Expand Placeholders says that it specifies the placeholder text inserted at argument/column value position.



That works for tables, for example, when picking a table from an INSERT popup, it inserts my define placeholder (@_$NAME$) in place of the values. I had expected that it would do the same when picking a stored procedure from the popup, so it would look like this:
#1
Code:

EXECUTE [logs].[usp_mlog]
    @severity = @_severity,
    @source = @_source,
    @category = @_category,
    @code = @_code,
    @message = @_message,
    @with_output = @_with_output


Though strictly interpreting the placeholder above should result in this code:
#2
Code:

EXECUTE [logs].[usp_mlog]
    @severity = @_@_severity,
    @source = @_@_source,
    @category = @_@_category,
    @code = @_@_code,
    @message = @_@_message,
    @with_output = @_@_with_output


But neither of those happened, I got this:
#3
Code:

EXECUTE [logs].[usp_mlog]
    @severity = null,
    @source = null,
    @category = null,
    @code = null,
    @message = null,
    @with_output = null


Check this short video here.

Which is worse than #1 but definitely better than #2. Nevertheless, Auto Expanding Placeholders for arguments does not seem to work.
Tue Oct 19, 2021 2:05 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7842

Post Reply with quote
I'm told that placeholders for procedures are currently supported for Oracle procedures only; and for table DML operations for all databases.
Wed Oct 20, 2021 11:57 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.