Re: Not able to execute function in a UDF

On 7/5/16 9:11 PM, Dinesh Bajaj wrote: CREATE FUNCTION invoice_total ( invoiceNumber int ) RETURNS DECIMAL LANGUAGE JAVA PARAMETER STYLE JAVA READS SQL DATA EXTERNAL NAME 'FXBilling.DBJAR.DBMethods.getInvoiceTotal' Hi Dinesh, It's hard to say what's going on. Could you share the Java code

Re: Updating several consecutive fields in a record

Thank you Bryan Simple and elegant :) Bob M -- View this message in context: http://apache-database.10148.n7.nabble.com/Updating-several-consecutive-fields-in-a-record-tp146385p146387.html Sent from the Apache Derby Users mailing list archive at Nabble.com.

Re: Updating several consecutive fields in a record

psUpdate = conn.prepareStatement("UPDATE SET PROFIT_LOSS = ? WHERE Now, I wish to update seven consecutive fields in the latest derby record You can list multiple columns in the UPDATE statement: UPDATE my-table SET col-1=?, col-2=?, col-3=? WHERE ... And then use multiple

Updating several consecutive fields in a record

Hi So far, I have only needed to update a single field in the latest derby record with code as follows:- // retrieve the latest trade record rs = s.executeQuery("SELECT * FROM ORDER BY TRADE_NO DESC NULLS LAST FETCH NEXT 1 ROW ONLY"); rs.next(); String Date3 = rs.getString("Trading_Date");