msaccess-vcs-addin
msaccess-vcs-addin copied to clipboard
incorrect SQL data type
trafficstars
Access 2013, addin versions 3/4/23 and 4.0.34
The SQL datatype must be mere "BYTE" not "unsigned byte", or the command fails
CREATE TABLE [Form] (
...
[Security] UNSIGNED BYTE ,
...
<xsd:element name="Security" minOccurs="0" od:jetType="byte" od:sqlSType="tinyint" type="xsd:unsignedByte">
<xsd:annotation>
<xsd:appinfo>
<od:fieldProperty name="ColumnWidth" type="3" value="-1" />
<od:fieldProperty name="ColumnOrder" type="3" value="0" />
<od:fieldProperty name="ColumnHidden" type="1" value="0" />
<od:fieldProperty name="Description" type="10" value="0 - Free access; 1- Private; 2 - Encrypted" />
<od:fieldProperty name="DecimalPlaces" type="2" value="255" />
<od:fieldProperty name="DefaultValue" type="12" value="0" />
<od:fieldProperty name="Required" type="1" value="0" />
<od:fieldProperty name="DisplayControl" type="3" value="109" />
<od:fieldProperty name="TextAlign" type="2" value="0" />
<od:fieldProperty name="AggregateType" type="4" value="-1" />
<od:fieldProperty name="ResultType" type="2" value="0" />
<od:fieldProperty name="CurrencyLCID" type="4" value="0" />
</xsd:appinfo>
</xsd:annotation>
</xsd:element>