I have a table of financial calculations where many fields are defined as FLOAT(126). When I try to create a datasource I get this error: Column IRR has unsupported data type: FLOAT. How can I manage these fields in Formspider? I tried to set Defaultnumber as domain to override initial data type, but nothing to do... Many thanks! Giuseppe

asked 04 Dec '14, 17:19

giuseppe_polo's gravatar image

giuseppe_polo
113
accept rate: 0%


Hi Giuseppe,

Formspider does not support the FLOAT data type yet. If possible, you can cast the FLOAT data type to NUMBER in SQL and use it. But then again, you will loose some precision which might be important.

Kind Regards,
Yalim

link

answered 05 Dec '14, 00:31

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
1.8k5
accept rate: 15%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×64
×4

Asked: 04 Dec '14, 17:19

Seen: 2,336 times

Last updated: 05 Dec '14, 00:31


© Copyright Gerger 2017