SQL Query Analyzer


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL Query Analyzer

  1. #1
    Join Date
    Aug 2004
    Posts
    43,023

    SQL Query Analyzer

    [Originally posted by Jack Mossman]

    I was wondering if anyone knew what functions or objects SQL Query Analyzer used to display the results of a query... I myself was trying to use the GetRangeString function of the SQL-DMO object but it is not formatting the size of the columns correctly. Is there any way to get the same results as the Query Analyzer???

  2. #2
    Join Date
    Aug 2004
    Posts
    43,023

    Re:SQL Query Analyzer

    [Originally posted by Simon E. White]

    Hi

    The following article on MSDN may help.

    INF: How to List the Results of a SELECT Query on a Table using SQL-DMO
    ID: Q241246

    Let me know if you have any luck!!!

    Simon

  3. #3
    Join Date
    Aug 2004
    Posts
    43,023

    Re:Re:SQL Query Analyzer

    [Originally posted by Jack Mossman]

    The article actually did not help. I was looking for a way to display the entire result of the query into a rich text box much like the SQL Query does. The closest thing I can get to it is the GetRangeString function, but there are a few quirks with this function: I can't get the dashed lines under the column titles to be the exact length of the column they are always one short (just an inconvience), for some columns the length is not enough to display the entire contents of the column, and when trying to break the query up by getting an x amount of rows at a time the formatting changes after the first batch and does not line up with the rest of the columns from then on. I am not sure if there is another way, I have not tried the API functions but I am unsure as to how to use them, anyone have any ideas?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center