Home > database >  A longlong type problems...
A longlong type problems...

Time:10-26

Meet a longlong type of problem,,,
In the program, defines a longlong type of variable, and assign a value to: ll_tid=1079507765416801
But in the data window assignment, the values in the data window automatically into: 1079507765416800,
Database using the Access database, the field is defined as double byte, because Access to support long integer can not store so long numerical,
Some people encountered such a problem? Really get dizzy with him,

CodePudding user response:

Just said is wrong, not double byte type, type is double,

CodePudding user response:

With decimal type

CodePudding user response:

The
refer to the original poster ss120909 response:
a longlong types of problems,,,
In the program, defines a longlong type of variable, and assign a value to: ll_tid=1079507765416801
But in the data window assignment, the values in the data window automatically into: 1079507765416800,
Database using the Access database, the field is defined as double byte, because Access to support long integer can not store so long numerical,
Some people encountered such a problem? Was he got dizzy,


Sure because the precision of question, guess is the precision of the data in the window, there is something wrong with your editsource have a look at the type of the column, if is number changed to decimal (0) should be ok

CodePudding user response:

To ACCESS can't support, it will save characters or other type,

CodePudding user response:

I've met, and finally change my field varchar
  • Related