D
DIOS
I have an Access database that I tap into via VB/DAO.
I store a file size (in bytes) in a field of size Long. When I developed
the app i didnt think anyone would ever have files larger than 2,147,483,647
which is what a Long will hold. But with the rising popularity of DVD
media i know must deal with file sizes larger than a Long.
Anyway, ive been thinking about changing the field size to a Decimal
which according to the documentation can hold up to
"With a scale of 0 (no decimal places), the largest possible value is
+/-79,228,162,514,264,337,593,543,950,335"
So if i transfer my data to the new field do i risk losing integrity?
Will my queries take longer? Will my app suffer in performance?
What will I lose and what will I gain? Thanx for any advice.
AGP
I store a file size (in bytes) in a field of size Long. When I developed
the app i didnt think anyone would ever have files larger than 2,147,483,647
which is what a Long will hold. But with the rising popularity of DVD
media i know must deal with file sizes larger than a Long.
Anyway, ive been thinking about changing the field size to a Decimal
which according to the documentation can hold up to
"With a scale of 0 (no decimal places), the largest possible value is
+/-79,228,162,514,264,337,593,543,950,335"
So if i transfer my data to the new field do i risk losing integrity?
Will my queries take longer? Will my app suffer in performance?
What will I lose and what will I gain? Thanx for any advice.
AGP