Skip to Content
0
Oct 05, 2013 at 08:14 PM

Insert into table fails Using XSJS

402 Views

Hello Experts,

I am using following code to to insert data in an table. But this gives error.

  1. var conn = $.db.getConnection();
  2. var pstmt = conn.prepareStatement('insert into \"SCHEMANAME.TABLENAME\" values(\'XXX\',\'20121006\',\'185712\', 12.0)');
  3. var rs = pstmt.execute();

My table looks like

Same insert statement works fine from SQL console.

How can I fix this error?

Please help.

Regards,

Atanu

Attachments

Capture.PNG (10.2 kB)