topic Re: Why is MOD(OBJECTID,30)=0 an invalid expression? in ArcGIS Pro Questions

Why is MOD(OBJECTID,30)=0 an invalid expression?

ElectraNetArcGIS — Fri, 08 Nov 2019 04:52:03 GMT

Why is MOD(OBJECTID,30)=0 an invalid expression?

I have a feature class with a field 'OBJECTID', it appears automatically when typing the SQL syntax. I tried this in v2.4 and 2.3. Both places it says invalid syntax. It works, however, in another map. The first OBJECTID value is 281. There are 290 records. If i create another field (LONG data type) and subtract 280 from the OBJECTID field and put the result in this new field, so it starts at 1, and then use that field in the MOD expression, it still fails. The data comes from a SDE.

Re: Why is MOD(OBJECTID,30)=0 an invalid expression?

DanPatterson_Retired — Fri, 08 Nov 2019 06:29:09 GMT

I hate queries. I prefer to add a field to the table so I have a record of whether a condition was met.

math.fmod(!OBJECTID!,2) == 0.0  # check for divisible by 2, returns 0 or 1‍

Re: Why is MOD(OBJECTID,30)=0 an invalid expression?

JoshuaBixby — Mon, 11 Nov 2019 21:06:45 GMT

Often times with enterprise geodatabases, the syntax is dependent on the specific DBMS. What DBMS are you using?

Re: Why is MOD(OBJECTID,30)=0 an invalid expression?

KoryKramer — Mon, 11 Nov 2019 21:56:09 GMT

It worked for me in file gdb:

Re: Why is MOD(OBJECTID,30)=0 an invalid expression?

JoshuaBixby — Mon, 11 Nov 2019 22:53:55 GMT

I was picking up on the "data comes from a SDE" part of the question. If the data is coming from SQL Server, MOD is not recognized, which may or may not be the issue.

Re: Why is MOD(OBJECTID,30)=0 an invalid expression?

curtvprice — Mon, 11 Nov 2019 23:00:37 GMT

SQL Server MOD is %:

OBJECTID % 30 = 0‍‍