SQL Server 'bigint' values are 8-bytes, or 64-bits. While VB.NET has a
specific SQL variable types to mirror each SQL Server data type, I'm working
in VB6. So what is the best way to manipulate, or at least retrieve and
store 64-bit values in SQL Server?
Considerations are:
1: Variant
2: Type value using a pair of 32-bit long integers.
3: A class object to handle it, and could track null values as well.
4: Other
What won't work include:
1: Double precision float (not enough precision)
2: Currency (can't handle the maximum 64-bit values)
Suggestions?
*David*
specific SQL variable types to mirror each SQL Server data type, I'm working
in VB6. So what is the best way to manipulate, or at least retrieve and
store 64-bit values in SQL Server?
Considerations are:
1: Variant
2: Type value using a pair of 32-bit long integers.
3: A class object to handle it, and could track null values as well.
4: Other
What won't work include:
1: Double precision float (not enough precision)
2: Currency (can't handle the maximum 64-bit values)
Suggestions?
*David*