FIX: OleDbCommand.Prepare method requires parameters of type '14' have an explicitly set Precision and Scale.
Friday, 13 July 2007
When using OLE DB data provider and the SmartDataSource Select command contains parameters, which have the their type set to Decimal, the following error occurs during runtime:
OleDbCommand.Prepare method requires parameters of type '14' have an explicitly set Precision and Scale.
SYMPTOMS
When using OLE DB data provider and the SmartDataSource Select command contains parameters, which have the their type set to Decimal, the following error occurs during runtime:
OleDbCommand.Prepare method requires parameters of type '14' have an explicitly set
Precision and Scale.
CAUSE
OLE DB .NET provider requires Decimal parameters to have their Precision and Scale
explicitly set. This is required only when calling the OleDbCommand.Prepare method.
SmartDataSource does not set this properties because they are specific for the OLE
DB provider.
RESOLUTION
The problem has been fixed in smartDBforms.NET 1.5 and later. SmartDataSource explicitly sets the Precision and Scale for OLE DB parameters. It
sets Precision to 15 and Scale to 10.
WORKAROUND
There is no known workaround.
APPLIES TO
smartDBforms.NET 1.4 and previous versions when used with OLE DB data provider.
|