View previous topic :: View next topic |
Author |
Message |
Rmravi Beginner
Joined: 24 Jun 2004 Posts: 12 Topics: 5
|
Posted: Wed Apr 26, 2006 8:04 am Post subject: Binding Prob |
|
|
While i am Binding my job i am getting sqlcode -117 sql STATE 42802 Can u help0 me to slove this
Thanks |
|
Back to top |
|
|
kolusu Site Admin
Joined: 26 Nov 2002 Posts: 12369 Topics: 75 Location: San Jose
|
Posted: Wed Apr 26, 2006 8:47 am Post subject: |
|
|
Rmravi,
A sqlcode of -117 is self explanatory. you have mismatch in the no: of columns your insert statement. Correct that.
Code: |
-117 THE NUMBER OF VALUES ASSIGNED IS NOT THE SAME AS THE NUMBER OF
SPECIFIED OR IMPLIED COLUMNS
Explanation: The number of insert values in the value list of the INSERT
statement is not the same as the number of object columns specified.
Alternatively, the number of values on the right side of an assignment in
a SET assignment statement or the SET clause of an UPDATE statement does
not match the number of columns on the left side.
System Action: The statement cannot be executed. No data was inserted
into the object table.
Programmer Response: Correct the statement to specify one and only one
value for each of the specified object columns.
|
Hope this helps...
Cheers
Kolusu _________________ Kolusu
www.linkedin.com/in/kolusu |
|
Back to top |
|
|
|
|