What are the challenges you face when working across database platforms? Take the survey

Format in a one line

rreisrreis Posts: 7 Bronze 2
edited September 16, 2009 5:13AM in SQL Prompt Previous Versions
SQL Prompt is one of the useful tools that I worked with. However when I want to copy a SELECT statement to an ASP file it is necessary to put all in one single line. Is there a way to do it?

Rui Reis


  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your post.

    I doubt you can do this at the moment.

    Workaround is that you can type the valid/required query without using enter key so that query will remain on the single line and than before using LAYOUT functionality of SQL Prompt copy paste the query in your ASP code.

    Hope the suggestion doesn't sound stupid :!:
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
Sign In or Register to comment.