I have a script with 60+ queries in it against a in_memory table. They all word great except when using CAST. It will work on a GDB directly but in_memory gives a invalid SQL statement error.
Lots of documentation shows using in_memory interchangeably in many arc tools. You think these limits would come up.
Ideally change it to make it work just like a GDB. If not please at least document these limitations. This hunt and pecking to see what works costs lots of time. Esp when you have no idea why since it does not say anywhere that in_memory is limited.
Please post any list if it does exist.
Thanks