Results 1 to 7 of 7

Thread: Weird Error

  1. #1
    Join Date
    Dec 2003
    Posts
    44

    Unanswered: Weird Error

    Heres some SQL I am trying to execute:

    INSERT INTO Contact_Info (First,Last,Age) VALUES ('Alex','Strait',19)

    Now it seems basic, but there in one more field that you're not supposed to specifiy a value in the SQL, its an int IDENTITY datatype field called num_id. Now this SQL works if it doesnt have the num_id field. But heres the error is gives me, I have never seen it before

    Microsoft OLE DB Provider for ODBC Drivers error '80040e57'

    [Microsoft][ODBC SQL Server Driver][SQL Server]String or binary data would be truncated.

    /neosql.asp, line 847

    Does anyone know what is wrong?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    What is the insert statement that gives you the error ?

  3. #3
    Join Date
    Dec 2003
    Posts
    44

    I gave it in first post

    Originally posted by rnealejr
    What is the insert statement that gives you the error ?
    INSERT INTO Contact_Info (First,Last,Age) VALUES ('Alex','Strait',19)

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    Now this SQL works if it doesnt have the num_id field
    So what statement works ?

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    What datatypes are these fields ? This error means that one of the fields exceeds your field definition.

  6. #6
    Join Date
    Dec 2003
    Posts
    44

    Thanks

    Oh Ok, thanks, I see whats wrong now

  7. #7
    Join Date
    Feb 2002
    Posts
    2,232
    You must have had some slim size definitions.

Posting Permissions

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