topic Re: &quot;Make Query Layer&quot; issue between ArcMap and Pro. in Python Questions https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442879#M34648 <HTML><HEAD></HEAD><BODY><P>If I run the tool in Pro it doesn't allow me to continue without selecting ARN or MOD_DATE before continuing. I tried typing in OBJECTID and it gives an error</P></BODY></HTML> Thu, 13 Jun 2019 17:55:17 GMT Anonymous User 2019-06-13T17:55:17Z "Make Query Layer" issue between ArcMap and Pro. https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442877#M34646 <HTML><HEAD></HEAD><BODY><P>If I&nbsp;run&nbsp;the following&nbsp;query in python 2.7&nbsp; it allows me to use OBJECTID as the unique ID field but in python 3 it does not. Does anyone know why or how to get it to work?</P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE><SPAN class="keyword token">SELECT</SPAN> <SPAN class="punctuation token">(</SPAN>ROW_NUMBER<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">OVER</SPAN><SPAN class="punctuation token">(</SPAN><SPAN class="keyword token">ORDER</SPAN> <SPAN class="keyword token">BY</SPAN> ARN<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> OBJECTID<SPAN class="punctuation token">,</SPAN> ARN<SPAN class="punctuation token">,</SPAN> MOD_DATE<SPAN class="punctuation token">,</SPAN> Shape <SPAN class="keyword token">FROM</SPAN> dbo<SPAN class="punctuation token">.</SPAN>vw_GC_ARN ‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><P></P><P>full code I was using:</P><P></P><PRE class="lia-code-sample line-numbers language-none"><CODE>arcpy<SPAN class="punctuation token">.</SPAN>MakeQueryLayer_management<SPAN class="punctuation token">(</SPAN> lro16<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"parcels"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"""SELECT (ROW_NUMBER() OVER(ORDER BY ARN)) as OBJECTID, ARN, MOD_DATE, Shape FROM dbo.vw_GC_ARN"""</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"POLYGON"</SPAN><SPAN class="punctuation token">,</SPAN> srid<SPAN class="operator token">=</SPAN><SPAN class="string token">"5320"</SPAN><SPAN class="punctuation token">)</SPAN>‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE></BODY></HTML> Sat, 11 Dec 2021 19:48:17 GMT https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442877#M34646 Anonymous User 2021-12-11T19:48:17Z Re: "Make Query Layer" issue between ArcMap and Pro. https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442878#M34647 <HTML><HEAD></HEAD><BODY><P>This could be how the GP tool is interpreting the column (Long vs Short integer) upon creation and may be a bug. If you run the GP tool manually in Pro, do you experience the same issue?</P></BODY></HTML> Thu, 13 Jun 2019 17:48:21 GMT https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442878#M34647 ChristianWells 2019-06-13T17:48:21Z Re: "Make Query Layer" issue between ArcMap and Pro. https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442879#M34648 <HTML><HEAD></HEAD><BODY><P>If I run the tool in Pro it doesn't allow me to continue without selecting ARN or MOD_DATE before continuing. I tried typing in OBJECTID and it gives an error</P></BODY></HTML> Thu, 13 Jun 2019 17:55:17 GMT https://community.esri.com/t5/python-questions/quot-make-query-layer-quot-issue-between-arcmap/m-p/442879#M34648 Anonymous User 2019-06-13T17:55:17Z