CurrencyValue small number creates error

  1. ‹ Older
  2. 2 years ago
    Edited 2 years ago

    Jean-Yves : yes it works, i rarely use it because i lost precision in taxes calculation, but the last calculation in the query i should use it to avoid that strange number :-)

  3. Norman : it return a number if you ask a number, but you can insert anything in a real / integer column. MySQL and PostGres you can't insert a string in a number column

  4. Norman P

    20 Mar 2017 Xojo Inc, Pre-Release Testers, Xojo Pro Seeking work. npalardy@great-w...

    Sure but that doesn't mean it uses strings
    Just that it does not enforce typing in the same way postgres etc do

or Sign Up to reply!