topic Re: Create a double field using the DDL in ArcGIS Pro SDK Questions

Create a double field using the DDL

mody_buchbinder — Thu, 24 Jun 2021 12:32:39 GMT

Hello all

We are trying to create layer with field with type double using the new DDL

The field in in layer in sql server.

It looks like the code ignore the scale and precision.

Trying to do the same with GP tool (Add Field) works.

Is this a bug, feature or something that will come in the next version?

Thanks

Re: Create a double field using the DDL

Aashis — Thu, 24 Jun 2021 19:28:37 GMT

Hi @mody_buchbinder , Could you please send us a code snippet that causing the issue? We are not able to reproduce the scenario that doesn't honor the scale and precision provided through DDL.

Version info of Pro and SQL Server are also helpful for further diagnosis.

The following field description successfully created a double field with scale and precision in our test.

FieldDescription doubleFieldDescription = new FieldDescription("TestDoubleField", FieldType.Double) { Scale = 3, Precision = 9 };

Re: Create a double field using the DDL

Wolf — Thu, 24 Jun 2021 22:01:48 GMT

Thanks for reporting this. ~~I was able to duplicate this problem.~~ I will report the issue to the Geodatabase team.

Re: Create a double field using the DDL

Wolf — Thu, 24 Jun 2021 22:01:06 GMT

I stand corrected. The Geodatabase team pointed out the error in my test add-in where I chose a scale larger than the precision. Once I fixed that error I get the proper result:

I used the following code snippet to create the feature class. The 'selectedFeatureLayer' is a feature layer I get from the TOC in order to get my database connection.

Re: Create a double field using the DDL

dkuida — Mon, 28 Jun 2021 08:41:18 GMT

Hello @Wolf

Here is the code, note that the database is a memory database.

And yet the result is:

private async Task CreateParcelTempLayers(Polygon parcelGeometry, bool shouldGeneralize) { var memoryConnectionProperties = new MemoryConnectionProperties(); var map = MapView.Active.Map; using var geodatabase = SchemaBuilder.CreateGeodatabase(memoryConnectionProperties); BuildEdgesLayer(map, geodatabase); } // and bellow private void BuildEdgesLayer(Map map, Geodatabase geodatabase) { var shapeDescription = new ShapeDescription(GeometryType.Polyline, map.SpatialReference); var fieldDescriptions = new[] { new FieldDescription(m_FromVertexToVertex, FieldType.String){Length = 50}, new FieldDescription(m_EdgeLength, FieldType.Double) { Scale = 2, Precision = 9, AliasName = ReportsManagerResources.ReportsManagerProxy_BuildEdgesLayer_DistancesAlias }, }; var featureClassDescription = new FeatureClassDescription(m_ParcelEdgesLayerName, fieldDescriptions, shapeDescription); var schemaBuilder = new SchemaBuilder(geodatabase); schemaBuilder.Create(featureClassDescription); var success = schemaBuilder.Build(); }

Would love to hear your feedback

Re: Create a double field using the DDL

Wolf — Mon, 28 Jun 2021 15:51:55 GMT

Thanks for reporting this, an ArcGIS Pro Geodatabase team member was able to duplicate this problem when using a memory Geodatabase. The issue will be fixed in an upcoming Pro release.