| 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 |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
