DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Joe Olsen Guest

    SQL wrapping issue


    I just switched from Windows 95 to Windows NT. Now when I query a SQL Server
    table in either ISQL or SQL Programmer, if there are more than a certain
    number of columns in the table and I do a 'Select * from...' the latter columns
    wrap and display over the first columns, making them unreadable. Any ideas
    on on how to fix this???

  2. #2
    C. E. Buttles Guest

    Re: SQL wrapping issue

    Get a really, really large monitor and set the resolution to very small
    letters. Actually, it has been my experience where the result comes up with
    a scroll bar to allow you to scroll left and right (or vice versa). Check
    your configuration in Query, Options, Format Options of Isql/w. Column
    aligned is the default. If you have something else, this may be the
    problem.


    "Joe Olsen" <jolsen@saionline.com> wrote in message
    news:38e4bdbe@news.devx.com...
    >
    > I just switched from Windows 95 to Windows NT. Now when I query a SQL

    Server
    > table in either ISQL or SQL Programmer, if there are more than a certain
    > number of columns in the table and I do a 'Select * from...' the latter

    columns
    > wrap and display over the first columns, making them unreadable. Any

    ideas
    > on on how to fix this???



  3. #3
    Laura Jacobowitz Guest

    Re: SQL wrapping issue


    I use SQL Programmer all the time and don't have this problem. I use it from
    NT, Win 2K, and 95. Are you having the problem when you print or when you
    view on the screen? If your data has embedded line returns it could cause
    some interesting results.
    "C. E. Buttles" <cebuttle@sprintsvc.net> wrote:
    >Get a really, really large monitor and set the resolution to very small
    >letters. Actually, it has been my experience where the result comes up

    with
    >a scroll bar to allow you to scroll left and right (or vice versa). Check
    >your configuration in Query, Options, Format Options of Isql/w. Column
    >aligned is the default. If you have something else, this may be the
    >problem.
    >
    >
    >"Joe Olsen" <jolsen@saionline.com> wrote in message
    >news:38e4bdbe@news.devx.com...
    >>
    >> I just switched from Windows 95 to Windows NT. Now when I query a SQL

    >Server
    >> table in either ISQL or SQL Programmer, if there are more than a certain
    >> number of columns in the table and I do a 'Select * from...' the latter

    >columns
    >> wrap and display over the first columns, making them unreadable. Any

    >ideas
    >> on on how to fix this???

    >



Bookmarks

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


Top DevX Stories

Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL


Sponsored Links