Expression used in ArcMap not working the same in Pro - Help

Question

So I'm trying to get this expression I have for our Mile Markers layer to work in Pro as it has in Arc Map, but I'm not sure what I'm missing. Please see screen shots for visual. In Arc Map I was able to use this expression in the labels SQL query window: mile_nmrc / 5 = ROUND(mile_nmrc / 5, 0) to show labels as every 5 miles apart. However, when doing this in Pro, it doesn't give me the values that are every 5 miles and I'm using the same expression within Label Properties - Class - SQL query. I have tried to put this expression within just the label expression, but that doesn't work there either.

ProExpression.png

MapExpression.png

WhatsApp Image 2024-10-09 at 2.22.35 PM.jpeg

Kristofer_0-1728545362943.png

DanaYoung · Answer

Okay thank you! I appreciate the help. And giving me a direction to look in.

jcarlson · Answer

Well, that's getting outside of the scope of Esri stuff. You'll have to ask your DB Admin or whomever manages that database to find out what platform it's running, whether it's MySQL, PostgreSQL, SQL Server, etc., and then go to that provider's documentation to see what functions are available to you.

DanaYoung · Answer

Yeah I just changed the source of that layer to the file geodatabase layer and all works just fine in pro. Do you know where I can find more information about these different databases and what functions with what for pro and online? I'm still new to some of these things. Thank you for your assistance!