Column issues

Discussion in 'SQL Server' started by savvy, Dec 28, 2006.

  1. savvy

    savvy New Member

    Joined:
    Dec 28, 2006
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    0
    I'm having a problem with SQL 2000 where for example the street address column is over writing the state column for every user that is entered. Everytime data is entered in to the state column it somehow grabs the data from the street address column when the proceed button on the app is depressed. Any assistance would be appreciated solving this.
     
  2. pradeep

    pradeep Team Leader

    Joined:
    Apr 4, 2005
    Messages:
    1,645
    Likes Received:
    87
    Trophy Points:
    0
    Occupation:
    Programmer
    Location:
    Kolkata, India
    Home Page:
    http://blog.pradeep.net.in
    Kindly check your sql query, it seems like you've goofed up the variable names in your application.

    Try and show the SQL query in a MsgBox before executing it.
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice