[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 225
  • Last Modified:

CREATING TABLE WITH SQL IN PERVASIVE

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?
0
BIAPRO
Asked:
BIAPRO
1 Solution
 
Pratima PharandeCommented:
use SMALLINT

strSQL = strSQL & "AflBesteld SMALLINT NOT NULL,"
0
 
BIAPROAuthor Commented:
Great !   thanks
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now