Data Types
[Memo Data Model]

Detailed Description

Memo Data Model Data Types.


Typedefs

typedef _AlpMemoDmlColumnType AlpMemoDmlColumnType
typedef _AlpMemoDmlSelectType AlpMemoDmlSelectType

Enumerations

enum  _AlpMemoDmlColumnType { kMemoLUID = 1, kMemoText, kMemoCreationDate, kMemoModificationDate }
enum  _AlpMemoDmlSelectType {
  kMemoDmlSelectAll = 1, kMemoDmlSelectAllOrderByAlpha, kMemoDmlSelectAllOrderByDate, kMemoDmlSelectAllInCategory,
  kMemoDmlSelectAllInCategoryOrderByAlpha, kMemoDmlSelectAllInCategoryOrderByDate, kMemoDmlSelectMemoInCategory, kMemoDmlSelectMemoInCategoryOrderByAlpha,
  kMemoDmlSelectMemoInCategoryOrderByDate, kMemoDmlSelectAllNoCategory, kMemoDmlSelectAllNoCategoryOrderByAlpha, kMemoDmlSelectAllNoCategoryOrderByDate
}

Typedef Documentation

typedef _AlpMemoDmlColumnType AlpMemoDmlColumnType
 

Memo data column type.

typedef _AlpMemoDmlSelectType AlpMemoDmlSelectType
 

Memo DML select criteria type.

Enumeration Type Documentation

enum _AlpMemoDmlColumnType
 

Enum of column types for a memo item create/get/set/destroy.

Enumerator:
kMemoLUID  AlpLuid.
kMemoText  String.
kMemoCreationDate  UInt32.
kMemoModificationDate  UInt32.

enum _AlpMemoDmlSelectType
 

The following are selection types for building a result set for a query. Queries can be done based on a sort order (optional), categorized (optional). The SQL query statements are listed next to each of the selection types. Note some selection types may produce similar or same result sets.

Enumerator:
kMemoDmlSelectAll  SELECT * FROM [table].
kMemoDmlSelectAllOrderByAlpha  SELECT * FROM [table] ORDER BY [field].
kMemoDmlSelectAllOrderByDate  SELECT * FROM [table] ORDER BY [field],.
kMemoDmlSelectAllInCategory  SELECT * FROM [table_A], [table_B] WHERE [table_B].id = [table_A].id AND [table_B].id = id.
kMemoDmlSelectAllInCategoryOrderByAlpha  SELECT * FROM [table_A], [table_B] WHERE [table_B].id = [table_A].id AND [table_B].id = id ORDER BY [field].
kMemoDmlSelectAllInCategoryOrderByDate  SELECT * FROM [table_A], [table_B] WHERE [table_B].id = [table_A].id AND [table_B].id = id ORDER BY [field].
kMemoDmlSelectMemoInCategory  SELECT id, [field] FROM [table_A], [table_B] WHERE [table_B].id = [table_A].id AND [table_B].id = id.
kMemoDmlSelectMemoInCategoryOrderByAlpha  SELECT id, [field] FROM [table_A], [table_B] WHERE [table_B].id = [table_A].id AND [table_B].id = id ORDER BY [field].
kMemoDmlSelectMemoInCategoryOrderByDate  SELECT id, [field] FROM [table_A], [table_B] WHERE [table_B].id = [table_A].id AND [table_B].id = id ORDER BY [field].
kMemoDmlSelectAllNoCategory  SELECT * FROM [table_A] WHERE [table_A].id NOT IN (SELECT [table_B].id FROM [table_B]).
kMemoDmlSelectAllNoCategoryOrderByAlpha  SELECT * FROM [table_A] WHERE [table_A].id NOT IN (SELECT [table_B].id FROM [table_B]) ORDER BY [field].
kMemoDmlSelectAllNoCategoryOrderByDate  SELECT * FROM [table_A] WHERE [table_A].id NOT IN (SELECT [table_B].id FROM [table_B]) ORDER BY [field].

Generated on Wed Jul 30 07:06:41 2008 by Doxygen 1.4.6 for ALP SDK + Hiker Documentation

Copyright © 1999-2008 ACCESS CO., LTD. All rights reserved.