Latest Contributions by TedChapin

I am experiencing this also.  Please reply with solution/workaround. Ted Chapin SGC Engineering. ... View more

Did you get any resolution on this issue?  I am experiencing the same thing. Ted Chapin SGC Engineering Westbrook, ME ... View more

You can use a MarkerSymbol with TextBox. Maybe create a two-way binding on a graphic.Attribute too if you want TextBox.Text saved per graphic.             <esri:MarkerSymbol x:Key="MySymbol">                 <esri:MarkerSymbol.ControlTemplate>                     <ControlTemplate>                         <TextBox Text="Type here"/>                     </ControlTemplate>                 </esri:MarkerSymbol.ControlTemplate>             </esri:MarkerSymbol> I can add a graphic with a textbox marker symbol, but it does not respond to the GraphicsLayer.MouseLeftButtonUp event.  I want to allow users to delete the text graphic with GraphicsLayer.Graphics.Remove(e.Graphic) in that event. Ted Chapin ... View more

Yes, CAST does work.  I had been using CAST(street_num AS varchar()), which is a lazy way to convert to string if you don't care about the string's length.  In T-SQL the default is 30 if it's not specified.  The REST API won't process varchar(), but this works: varchar(5), or whatever length is appropriate. ... View more

Those SQL statements work.  Try this query: UPPER(MBLU) LIKE '%106 LEDGE RD%' OR UPPER(Grantee) LIKE '%106 LEDGE RD%' OR UPPER(Co_grantee) LIKE '%106 LEDGE RD%' OR CONCAT(Street_Number, CONCAT(' ', Street_Name)) LIKE '%106 LEDGE RD%' on this table: https://eis.woodardcurran.com/ArcGIS/rest/services/PublicServices/Ogunquit/MapServer/22/query Wish there was some documentation about what the REST query's where clause supports. ... View more

Yes, the address number and street name are in separate fields.  But I want to keep my UI googlish with only 1 input box.  I actually simplified the query for my post.  I search for MBL, owner name, and address with 1 user text box.  When the MBL, owner name, street number, and street name fields are all string, it works with this query: query.Where = String.Format("UPPER(MBLU) LIKE '%{0}%' OR UPPER(Owner) LIKE '%{0}%' OR UPPER(Co_owner) LIKE '%{0}%' OR CONCAT(Street_Number, CONCAT(' ', Street_Name)) LIKE '%{0}%'", SearchText.Text.ToUpper) But one town I work with has a numeric field type for the street number.  SO, I would like to do something like this: query.Where = String.Format("UPPER(MBLU) LIKE '%{0}%' OR UPPER(Owner) LIKE '%{0}%' OR UPPER(Co_owner) LIKE '%{0}%' OR CONCAT(CAST(Street_Number AS varchar()), CONCAT(' ', Street_Name)) LIKE '%{0}%'", SearchText.Text.ToUpper) But CAST (or at least the varchar data type) doesn't seem to be supported by whatever version of SQL the REST API uses.  Neither does CONVERT.  The documentation doesn't go into any detail about what SQL statements are allowed.  I just guessed about CONCAT and UPPER. It may be that, in order to keep my search UI to one text box to search all those fields, I will have to modify the table schema to make the street number field a string. ... View more

I just discovered that if the Query.ReturnIdsOnly property is set to True, then the ObjectIDs property of the FeatureSet of the result is populated, but the features themselves are not.  If this property if False, then you get features but not the ObjectIDs.  Weird. I manually created a List(of Integer), looped through the FeatureSet and added the object ID's using feature.Attributes("OBJECTID").  Not my favorite approach but it worked. Ted Chapin ... View more