msaccess-vcs-addin icon indicating copy to clipboard operation
msaccess-vcs-addin copied to clipboard

incorrect SQL data type

Open the-Arioch opened this issue 1 year ago • 7 comments
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>

the-Arioch avatar Sep 06 '24 11:09 the-Arioch