Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    73

    Unanswered: View Columns Switched

    I'm having an odd issue with SQL Server. What happens is the following:
    I create view1. I then create view2 which uses view1. I then create view3 which uses view2.
    Then, if I make a change in View1, my other views are messed up. What happens is that columns in view3 (and view2) will be switched. Therefore, if a crystal report for example references view3, I'll suddenly get an exception due to a field in the cyrstal report thinking it's going to get an integer but gets a date instead. It's as if the columns were moved around.

    Is this a known issue with SQL Server 2000? Has someone else had that here? Has someone resolved that here?

    thx.

  2. #2
    Join Date
    Feb 2003
    Location
    Brisbane, Australia
    Posts
    110
    You shouldn't be doing a "SELECT *" in any query's anyway. Explicitly define each column that you want returned in both creating your views and your crystal reports.

  3. #3
    Join Date
    Oct 2003
    Posts
    73
    Thx for the reply. I will give that a try as soon as i can. For the time being, i simply just removed the query and then recreated it. All was fine after that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •