Minty
AWF VIP
- Local time
- Today, 11:31
- Joined
- Jul 26, 2013
- Messages
- 10,640
I came across an interesting gotcha the other day.
From a linked SQL server backend we were generating a sequence number using the Rank() Over function.
This returns a BigInt data type, it appears that Access Runtime 2016 version doesn't recognise this datatype, but I can't find any official listings for Runtime version where it says they are supported?
Does anyone know or is able to test, I've temporarily lost custody of my spare machine with the runtime(s) installed so it's currently awkward to trial the different versions.
Obviously have solved the immediate issue by casting the result to a normal SQL integer (It's never going to be a big int in value!)
From a linked SQL server backend we were generating a sequence number using the Rank() Over function.
This returns a BigInt data type, it appears that Access Runtime 2016 version doesn't recognise this datatype, but I can't find any official listings for Runtime version where it says they are supported?
Does anyone know or is able to test, I've temporarily lost custody of my spare machine with the runtime(s) installed so it's currently awkward to trial the different versions.
Obviously have solved the immediate issue by casting the result to a normal SQL integer (It's never going to be a big int in value!)