ADO.NET Provider for Certinia

Build 25.0.9434

ReportExactPicklistLength

Specifies whether to report the exact length of picklist fields as defined in Certinia, or to report them with a default length of 255.

Data Type

bool

Default Value

false

Remarks

By default, the provider reports all picklist fields with a length of 255, regardless of their actual length in Certinia. This simplifies schema definitions, but may not accurately reflect field constraints.

When this property is set to true, the provider reports each picklist field with its exact length as defined in the Certinia metadata. This is helpful for applications or integrations that require strict adherence to field size constraints.

Reporting exact lengths may slightly increase the complexity of schema discovery but ensures accurate metadata for data validation and form generation. Using a fixed length of 255 simplifies schema management but may cause issues if values exceed the actual limits enforced by Certinia. This property should be enabled when working with systems that need to respect Salesforce’s exact field constraints for picklist fields.

This property is useful for developers or data architects who require precise metadata for picklist fields when designing integrations, forms, or validation logic.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434