SoftTree Technologies Technical Support Forums Register • Search • FAQ • Memberlist • Usergroups • Log in PROMPT macro issue      SoftTree Technologies Forum Index » SQL Assistant View previous topic View next topic PROMPT macro issue Author Message gemisigo Joined: 11 Mar 2010 Posts: 2165 PROMPT macro issue The snippet below was created using the Create PROMPT macro dialog with "DECIMAL(18,2)" and "DECIMAL(18,4)" as Data values. SA escaped commas with a backslash. Code: $PROMPT(cast_type,,,,DECIMAL(18\,2) DECIMAL(18\,4))$ CAST($CURRENT_SEL$ as $cast_type$)| But when triggering the snippet, instead of getting two option in the dropdown menu, there are four of them: Quote: DECIMAL(18, ,2) DECIMAL(18, ,4) It seems that though the comma was escaped and hence it was displayed, its effect was still applied and the entry was broken in two. Mon Jul 09, 2012 5:26 am SysOp Site Admin Joined: 26 Nov 2006 Posts: 7948 Thank you very much for your feedback. I was able to reproduce this issue locally and submitted new ticket for this bug #SA0019884 Mon Jul 09, 2012 6:44 pm Display posts from previous:  All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year  Oldest FirstNewest First     SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours Page 1 of 1   Jump to:  Select a forum ----------------SQL AssistantDB Audit, DB Mail, DB Tools24x7 Scheduler, Event Server, Automation SuiteTips & Snippets Repository 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.