SQL ERROR

  • Hi Guys.

    I am trying to run an application to access a SQLServer, and when i try to open a table i get a very annoying error message.

    Multiple-Step Operation Generated Erros, Check Each Value Status!

    Can anyone tell what this means?

    Thanks.

     

     

  • I have never seen this, it does not appear to be a sql or connection error. Possibly an application error.

    What app are you using?

  • I have designed my own Application, using delphi 6 and ADO to connect to SQLSERVER 2000, the error occurs when i try to open the table to insert data.

  • I've seen this error in ADO when you stick a string into a varchar that is smaller than the string...ie sticka  30 character string into a varchar(20), and the ADO object returns multi step operation error.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • Here're other possiblities...source - googled site...

     This error means that one or more fields you are inserting/updating contain an invalid value. Some of the possible scenarios are:
    
    1. A string value is being inserted into a numeric field.
    2. An invalid date expression is being inserted into a date field.
    3. A string value being inserted is longer than the size of the string field.
    4. A null value is being inserted into a field that does not allow nulls. 
    







    **ASCII stupid question, get a stupid ANSI !!!**

  • Thanks a lot Guys.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply