Post reply

SQL ERROR

  • September 15, 2005 at 4:40 pm

    #89776

    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.

     

     

  • September 15, 2005 at 4:51 pm

    #590389

    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?

  • September 15, 2005 at 5:07 pm

    #590392

    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.

  • September 16, 2005 at 6:10 am

    #590516

    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!

  • September 16, 2005 at 7:30 am

    #590570

    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 !!!**

  • September 16, 2005 at 9:20 pm

    #590778

    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