Posted on 2011-05-03
Last Modified: 2012-05-11
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?
Question by:BIAPRO
    LVL 39

    Accepted Solution

    use SMALLINT

    strSQL = strSQL & "AflBesteld SMALLINT NOT NULL,"

    Author Comment

    Great !   thanks

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Top 6 Sources for Identifying Threat Actor TTPs

    Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Read about achieving the basic levels of HRIS security in the workplace.
    This tutorial will give a an overview on how to deploy remote agents in Backup Exec 2012 to new servers. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as connecting to a remote Back…
    This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    13 Experts available now in Live!

    Get 1:1 Help Now