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 North of 50

    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!