on 06-15-2017 1:00 PM
Hi,
I try to create a table entry with xsjs.
For the key-field I use an hdbseqence.file.
When I debug the source, copy the SQL Statment and use it in the SQL-Console everything works fine.
What's wrong with my xsjs file?
function create(key) {
var mnumber = key;
var conn = $.hdb.getConnection();
var query = 'insert into "KKH_SM.Development.DDIC::Contact.Detail" values("KKH_SM.Development.DDIC::contactSeq".NEXTVAL,\'\',\'\',\'\',\'\',\'\',\'\',\'\',\'\',' +
mnumber
+ ',\'\');';
try {
var qResult = conn.executeQuery(query);
$.response.setBody(qResult.toString());
$.response.status = $.net.http.OK;
} catch (ex) {
$.response.setBody(ex.message.toString());
$.response.status = $.net.http.BAD_REQUEST;
}
conn.close();
}
Regards Klaus
As you doing an insert you should use the executeUpdate method of the connection object instead of executeQuery. You also have to do a commit (using the commit method of the connection object) after your insert statement, because for the $.hdb connection object the autocommit mode is not activated by default.
Please check the $.hdb.Connection reference for more details.
Regards,
Florian
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.