CPDB.Net

https://cpdb.ppcompiler.org/

4- Fields operations (CPDB library)

Introduction

In the current version, 4 types of fields are supported :

CPDB_TYPESHORTINT : Short Integer, 1 octet, from -128 to 127
CPDB_TYPEINT : Integer, 2 octets, from -32768 to 32767
CPDB_TYPELONGINT : long integer, 4 octets, from -2147483648 to 2147483647
CPDB_TYPESTRING : a string, ascii zero terminated

Read a string field

Use the following example :

Err err;
MemHandle handle;
Char *string;

err = CPDB_ReadString(mydbHandle, "FIELDNAME", &handle);
if (err == 0)
{
  string = MemHandleLock(handle);
  // Use the string now
  // ...
  // Free the string
  MemHandleUnlock(handle);
  MemHandleFree(handle);
}

Important : the CPDB_ReadString function allocate the memory for you, so you must free this memory after use.

Read a numeric field

Use the following example :

Short integer :

Int8 int8;
err = CPDB_ReadShortInt(hOREST, "FIELDNAME", &int8);

Integer :

Int16 int16;
err = CPDB_ReadInt(hOREST, "FIELDNAME", &int16);

Long integer :

Int32 int32;
err = CPDB_ReadLongInt(hOREST, "FIELDNAME", &int32);

More information