Re: Firebird - numeric & decimal

2016-11-01 Thread Lionel Elie Mamane
Here's some example code to test this in Basic: Sub Tst dim stmt as object stmt=ThisDatabaseDocument.currentController.ActiveConnection.createStatement() dim rs as object rs = stmt.executeQuery("SELECT * FROM ""Table1""") dim rsmd as object rsmd =

Re: Firebird - numeric & decimal

2016-10-31 Thread Lionel Elie Mamane
On Mon, Oct 31, 2016 at 04:42:12PM +0100, Bunth Tamás wrote: > I tried to solve bug 74172 > https://bugs.documentfoundation.org/show_bug.cgi?id=74172 > but I got stuck: > In case of setting a numeric or decimal number the LO code calls the > prepared statement's setInt function, which has only

Firebird - numeric & decimal

2016-10-31 Thread Bunth Tamás
Hi, I tried to solve bug 74172 https://bugs.documentfoundation.org/show_bug.cgi?id=74172 but I got stuck: In case of setting a numeric or decimal number the LO code calls the prepared statement's setInt function, which has only an integer value as parameter, but no scale. I assumed first that