decimal number in dbpro
Quote from s7shanbe on April 15, 2022, 12:38 pmhello
In the dbpro plugin,
decimal numbers are not stored properly in the bigint field.
For example, 3.5 is stored 35
What is the problem?
hello
In the dbpro plugin,
decimal numbers are not stored properly in the bigint field.
For example, 3.5 is stored 35
What is the problem?
Quote from luishp on April 15, 2022, 10:27 pm@s7shanbe bigint stores "big integers". An integer is, by definition, a number with no decimal values.
You should use a field type that supports decimal values (float or "floating point").Regards.
@s7shanbe bigint stores "big integers". An integer is, by definition, a number with no decimal values.
You should use a field type that supports decimal values (float or "floating point").
Regards.
Quote from luishp on April 15, 2022, 10:28 pm
Understanding Numerical Data Types in SQL | LearnSQL.com
More on this here:
Understanding Numerical Data Types in SQL | LearnSQL.com
Quote from s7shanbe on April 17, 2022, 6:19 pm@luishp
thank you
I am using an access database. The float data type also does not display decimal numbers.
Can I create a SQL database with dbpro?
thank you
I am using an access database. The float data type also does not display decimal numbers.
Can I create a SQL database with dbpro?
Quote from luishp on April 18, 2022, 9:13 am@s7shanbe
Please take a look here:
https://docs.microsoft.com/en-us/office/troubleshoot/access/decimal-value-rounded-up-down-integerCan I create a SQL database with dbpro?
Access is a SQL database. SQL is just a language for storing, manipulating and retrieving data in databases.
Regards.
Please take a look here:
https://docs.microsoft.com/en-us/office/troubleshoot/access/decimal-value-rounded-up-down-integer
Can I create a SQL database with dbpro?
Access is a SQL database. SQL is just a language for storing, manipulating and retrieving data in databases.
Regards.