So I’ve created a new class in the database meant for me to manually save information to.
One of the values I want to store is of type BigNumber but when I create a new column and select that type from the dropdown I get an error: invalid field type: NumberDecimal
Other types like number and string work fine though. And I know it’s possible because I have a class created from synced events that does have a column with type BigNumber and that one works fine.
Am I missing something?
I know that there is that numberDecimal user for event sync tables, I think that the table is created from code in that case and not from the interface
can you try to create a table from code?
I don’t think it works via code neither.
I’ve tried a couple of different values and these are the types of columns created:
ethers.BigNumber (which is really a an object {_isBigNumber, _isHex}) => object
hex (from the BigNumber) => string
decimal => number
number => number
It’s worth noting that while it seems to be a column type in the interface, it is not mentioned in the documentation https://docs.moralis.io/moralis-dapp/database/objects#data-types
Anyway, I’ve created a string column for it now so it’s not a big issue.