Skip to Content
0
Former Member
May 07, 2013 at 08:58 AM

Problem updating table using XSJS

894 Views

Hello,

I'm trying to update a table using xsjs using the following code:

var query = 'UPDATE "ABC"."TABLENAME" SET SOMEFIELD = ?';var pstmt = conn.prepareStatement(query);pstmt.setString(1, 'test');pstmt.executeUpdate();conn.commit();

This unfortunately doesn't work.

I've tried to debug this, and when executing line 4 it crashes.

2 questions:

- Is there an obvisous mistake?

- In the debugger view where can I see what's going wrong? Debugging without error messages is not so helpfull...

FYI: When I do a INSERT instead of an UPDATE it works fine.

Thanks a lot for any help!