on 04-16-2015 5:31 AM
Hi All
I have created a table using .hdbtable definition. I have also created an .xsodata service to fetch the details of the table. The problem is when trying to insert data into the table.
For this, I created a procedure. But when I tried to activate I am getting an error which says "Invalid column name".
But the Column name which is provided is correct.
I am stuck and not able to proceed. Please help.
Thanks in advance
Meenakshi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
No Meenakshi, from what you have shared, I am unable to say what is the problem. Does the system point out the specific line that has the error? Also, I see that EmpId is the first field in the table (and therefore in the statements in the procedure). Maybe you can try removing this field from the code in the procedure and see if you still get the error or not. That will tell you whether it is actually a problem with the EmpId field or a generic problem with the syntax.
This also seems like the error message is pretty dead on. It says the EmpId field can't be null. Therefore it would seem your EmpId variable in the setString must be null. You don't show the whole code block so we can't see where this variable is coming from; but from the error that would certainly seem to be the source of this problem.
But going back to your original problem in the SQLScript procedure: If you are going to use mixed case columns, they you have to put the column names in quotes. That's the source of that original error.
Can you post screenshots of your table definition and the procedure you've written to insert a record?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.