Latest Contributions by HalilSiddique

Hi, I have a need to add a what3words address to the point that will be collected on FieldMaps The steps shown here https://developer.what3words.com/tutorial/how-to-add-the-what3words-locator-to-arcgis-online-and-field-maps suggest i can copy and paste the address into a field, which is fine, but does anyone know if it possible to populate a field automatically with the what3words address instead? thanks ... View more

Hi, I have just started playing around with Survey123. What i would like to do is allow the user input a postal code within a single text box, that postal code is sent to the web api and all the matching records are then shown within a dropdown menu, which they then select the appropriate address. Is this possible in Survey123 version 3.12? thanks ... View more

Hi, I have just had a quick look at our ArcGIS Server log files and seem to have found some errors that relate to getting the data for a particular map service. SEVERE Sep 12, 2013 10:14:21 PM There is an error during the draw Licences (1.) Underlying DBMS error [ORA-00920: invalid relational operator ::SELECT /*+ LEADING INDEX(S_ S1360_IX1) INDEX(SHAPE F1360_UK1) INDEX(LICENCES A1360_IX1) */ SHAPE, IMPACT, OBJECTID ,S_,(2.) eminx,S_,(3.) eminy,S_,(4.) emaxx,S_,(5.) emaxy ,SHAPE,(6.) fid,SHAPE,(7.) numofpts,SHAPE,(8.) entity,SHAPE,(9.) points,SHAPE,(10.) rowid FROM (SELECT /*+ INDEX(SP_ S1360_IX1) */ DISTINCT sp_fid, eminx, eminy, emaxx, emaxy FROM SY_DES_CHYMP_OVERNIGHT,(11.) S1360 SP_ WHERE SP_,(12.) gx >= :1 AND SP_,(13.) gx <= :2 AND SP_,(14.) gy >= :3 AND SP_,(15.) gy <= :4 AND SP_,(16.) eminx <= :5 AND SP_,(17.) eminy <= :6 AND SP_,(18.) emaxx >= :7 AND SP_,(19.) emaxy >= :8) S_ , SY_DES_CHYMP_OVERNIGHT,(20.) LICENCES , SY_DES_CHYMP_OVERNIGHT,(21.) F1360 SHAPE WHERE S_,(22.) sp_fid = SHAPE,(23.) fid AND S_,(24.) sp_fid = SY_DES_CHYMP_OVERNIGHT,(25.) LICENCES,(26.) SHAPE AND (( false ))] [SY_DES_CHYMP_OVERNIGHT,(27.) Licences]. Roadworks2.MapServer VMGISAPP03.CORPOFLONDON.GOV.UK 103800  null 5432 12664 DrawGraphicCursor.NextGraphic and also WARNING Sep 13, 2013 12:01:56 AM The Layer:'Precautionary Road Gritting' in Map:'Layers' is invalid. The base table definition string "SY_DES_CLEANSING.Mech_Gritting_CWays_Pri1" is invalid. DBMS table not found [ORA-00942: table or view does not exist ] [SY_DES_CLEANSING.Mech_Gritting_CWays_Pri1][STATE_ID = 290768]. COLGIS_Road_Gritting.MapServer VMGISAPP03.CORPOFLONDON.GOV.UK 10801   17276 9824 MapServer.Connect Has anyone else had similar errors or have any suggestions on what can be done to fix these? Just a point on the second code - the layer does exist which is why I'm confused. Thanks Halil ... View more

Hi All, I am working on a VBA app, and I am having trouble with running sql using the executeSQL method. I have a table and a SDE featureclass, i want to insert all the records from a particular field from the featureclass into the table. The code i am trying to run is..                sql = " insert into DP_TEMP (DP_REF)" + _                        " select DP_REF " + _                        " from SY_CSY_CPAT.CITY_DEVELOPMENT_PIPELINES"                pWS.ExecuteSQL sql But when the code is run - no errors appear, but the table is empty. Has anyone got any idea on why it is not working. Thanks ... View more