<div>
Great ! &nbsp; thanks<br />

</div>


<div>
<div class="content wysiwyg-content">
I need to create a table in Pervasive , all goes well ,<br />
except I need a length for the Integer in the call off 2 bytes but it will create allways 4 bytes:<br />
<br />
This I do:<br />
&nbsp; &nbsp; strSQL = strSQL &amp;&nbsp;&quot;AflBesteld INT &nbsp;NOT NULL,&quot;<br />
&nbsp; &nbsp;<br />
what can I do to get 2 bytes for this field?<br />

</div>
</div>


I need to create a table in Pervasive , all goes well ,
except I need a length for the Integer in the call off 2 bytes but it will create allways 4 bytes:

This I do:
    strSQL = strSQL & "AflBesteld INT  NOT NULL,"
   
what can I do to get 2 bytes for this field?


CREATING TABLE WITH SQL IN PERVASIVE

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.