Pocket Access - IV

Finishing off where I left the previous post, the MSysProcs has only two columns:

• ProcName - Procedure name


• SQLText - SQL command

This table is generally empty (I've never seen an instance where it wasn't).

Now, let's look at column types. We cannot confuse CEDB column types with Pocket Access column types. CEDB types are limited to (C/C++):

#define CEVT_I2       2   // short
#define CEVT_UI2      18  // unsigned short
#define CEVT_I4       3   // int
#define CEVT_UI4      19  // unsigned int
#define CEVT_FILETIME 64  // FILETIME
#define CEVT_LPWSTR   31  // LPWSTR
#define CEVT_BLOB     65  // BYTE*
#define CEVT_BOOL     11  // BOOL
#define CEVT_R8       5   // double

I defined these in C# for my previous article as:

public enum CeDbType : ushort
{
    Int16    =  2,
    UInt16   = 18,
    Int32    =  3,
    UInt32   = 19,
    FileTime = 64,
    String   = 31,
    Blob     = 65,
    Bool     = 11,
    Double   =  5
}

Pocket Access types resemble SQL types and are more varied. From the online documentation found on the Windows CE SDKs, we can derive the following C# enum:

public enum SqlDataType : short
{
    Unknown       =  0,
    Char          =  1,
    Numeric       =  2,
    Decimal       =  3,
    Integer       =  4,
    Smallint      =  5,
    Float         =  6,
    Real          =  7,
    Double        =  8,
    DateTime      =  9,
    Time          = 10,
    TimeStamp     = 11,
    VarChar       = 12,
    LongVarChar   = -1,
    Binary        = -2,
    VarBinary     = -3,
    LongVarBinary = -4,
    BigInt        = -5,
    TinyInt       = -6,
    Bit           = -7
}